Compare two datatables and copy sum of column from one datatable to another

Hi ,

I have two datatables Dt1 and Dt2. I want to compare Name and location in both these datatables and if it matches, then I want to copy the sum of column “cost” from Dt2 to a column “price” in Dt1.

Since no. of rows in Dt are>10k, please suggest a way through linq


LINQ is not faster. It’s a myth. LINQ still loops through the data, it’s just hidden behind an abstraction layer.

I have tried searching the forum but not found a similar problem resolved.