Hi all,
i managed to join 2 datasets using left outer join LINQ:
Now how can i join more than 2 datasets using left outer join LINQ?
this is the sql:
i managed to join 2 datasets using left outer join LINQ:
VB.NET:
Dim myListOfAnonymousTypes = (From T1 In ds.Tables("dateTotal") Group Join T2 In ds.Tables("Total") On T2("summary") Equals T1("summary") Into left1 = Group From T2 In left1.DefaultIfEmpty Select Summary = T2("summary"), Total = If(T2("total"), 0), date1 = If(T1("dateTotal"), 0))
Now how can i join more than 2 datasets using left outer join LINQ?
this is the sql:
VB.NET:
SELECT v_weekTotal.summary, v_weekTotal.total, v_date1.date1, v_date2.date2, v_date3.date3, v_date4.date4, v_date5.date5, v_date6.date6, v_date7.date7
FROM v_weekTotal
LEFT OUTER JOIN
v_date1 ON v_weekTotal.summary = v_date1.summary
LEFT OUTER JOIN
v_date2 ON v_weekTotal.summary = v_date2.summary
LEFT OUTER JOIN
v_date3 ON v_weekTotal.summary = v_date3.summary
LEFT OUTER JOIN
v_date4 ON v_weekTotal.summary = v_date4.summary
LEFT OUTER JOIN
v_date5 ON v_weekTotal.summary = v_date5.summary
LEFT OUTER JOIN
v_date6 ON v_weekTotal.summary = v_date6.summary
LEFT OUTER JOIN
v_date7 ON v_weekTotal.summary = v_date7.summary