Hello, I have a linq that I need to use to compare dt1 and dt2 and produce a result of dt3. dt3 should be a data table that shows all the rows in dt1 which do not match the rows in dt2. Below is my linq, but i am getting a compiler error which says that the Operator ‘AND’ is not defined for IEnumerables. Your help would be greatly appreciated
From a In dt1.AsEnumerable() Join b In dt2.AsEnumerable
On a(“PAN”).ToString.Trim Equals b(“PAN”).ToString.Trim And a(“Amt”).ToString.Trim Equals b(“Amt”).ToString.Trim
Where a(“PAN”).ToString.Trim.Except(b(“PAN”).ToString.Trim)And (a(“Amt”).ToString.Trim.Except(b(“Amt”).ToString.Trim))
Select a