This is the second time that I am trying to ask this question and I
am refusing to believe that there is nobody on this group that doesn't
run in to the same problem
i am trying to convert following sql
statment to DbLinq one :
SELECT TLOG.KLINE,
TT.TRANSDES,
TLOG.REQUESTDATE,
TLOG.TRACK_2,
CT.CREDIT_TYPEDES,
TC.TRANSCODEDES,
VAL.VALIDATIONDES
FROM DEMO$MED_XORTRANSLOG TLOG
JOIN DEMO$MED_XORTRANSTYPE TT ON TLOG.TRANSTYPE = TT.TRANSTYPE
JOIN DEMO$MED_XORTRANSCODES TC ON TLOG.TRANSCODE = TC.TRANSCODENAME
JOIN DEMO$MED_XORCREDIT_TYPES CT ON TLOG.CREDIT_TYPE =
CT.CREDIT_TYPE
JOIN DEMO$MED_XORVALIDATION VAL ON TLOG.VALIDATION =
VAL.VALIDATIONNAME
JOIN DEMO$CURRENCIES CUR ON TLOG.CURRANCY = CUR.CURRENCY
So i begun from this sample that appears in
link_standard_query_operators pdf file:
var totalResult = t.MedXOrTRanSlog
.Join(t.MedXOrTRanStyPe, c => c.TRanStyPe, o =>
o.TRanStyPe,
(c, o) => new { c.CardNo, o.TRanSdEs});
and I am stuck now couse as you can see i need to keep join columns
Somebody any ideas????
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
