I think your question isn't specific to dblinq. You may need to ask it on StackOverflow, I've had good luck there. I'm pretty sure LINQ can return a plain datatable but I'm not sure how since I'm very new to it as well.
On Sun, Feb 15, 2009 at 4:35 AM, [email protected] <[email protected]>wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
