Compare Two Datatable using Linq

[supermanPunch (Arpan)]

Hi @RVK ,

Have you checked the post below :

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)