Comparison of two tables using Linq

[ppr (Peter Preuss)]

@kumar.varun2
the case has a chance to get turned from full outer join to left join (dt2 - to - dt1)

I will have a look on it later. In the meanwhile find a demo on left join done with LINQ here:

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)