How to left join two tables using Linq Query with all data in left table? Please Help

@GuhanTM
In general this could be done with Group Join

(From d1 In dtData1.AsEnumerable
Group Join d2 In dtData2.AsEnumerable On d1(0) Equals d2(0) Into gj = Group
From g In gj.DefaultIfEmpty
Select ra = {d1(0), d1(1) ,If(isNothing(g), Nothing, g(1)) }
Select dtResult.Rows.Add(ra)).CopyToDataTable

find starter Help here:
LINQ_LeftOuterJoin.xaml (9.7 KB)

11 Likes