Filter DataTable1 by excepting rows from DataTable2 by comparing specific column

give a try at

dtResult =

(From d in dt1.AsEnumerable
Let raf = d.ItemArray.Take(8)
Let chk = dt2.AsEnumerable.Any(Function (d2) d2.ItemArray.Take(8).SequenceEqual(raf))
Where not chk
Select r =d).CopyToDataTable

Assumption:

  • both dts are defining the same datacolumns and its DataTypes
  • no trims needed

Empty Filterresult handling: