compare 2 datatables using linq in c#

Question

i want to compare 2 datatables in which it first check for primary key  and then check for another changes in row below code works without primary key how can i use primary key in bellow code ? DataTable Final = dt1.AsEnumerable().Except(dt2.AsEnumerable() DataRowComparer.Default).CopyToDataTable();

Pops Fale · Answer

checked all link  there is no any linked between both column by primary key  the code must have to do following things 1) both dataTable must be linked with primary key 2) first it will check for primary key linking and then changes in row 3) result will be umatched row based on primary key and updated row data Thanks In Advance !

Vinay Singh · Answer

Hi Try the below link http://www.codeproject.com/Tips/344792/Compare-two-datatable-using-LINQ-Query http://dotnetmentors.com/adonet/datatable-comparison-using-linq-except-intersect-union.aspx http://stackoverflow.com/questions/10984453/compare-two-datatables-for-differences-in-c