I have two datatabales, Dt1 and Dt2.
I want to check if columns “Seller Name and Doc No.” from Dt1 are matching with “Party Name and Bill No,” from Dt2, then I want to get the Acc No. and Date columns details from Dt2 and paste it in Dt1.
Since both Dt1 and Dt2 have excel rows exceeding 80k, I want to use either select, enumerable or linq query to reduce execution time. Please help in this regard!