I am trying to filter line items from one data table which are not present in the master data table using a linq query .
But while executing the query is taking a lot of time to execute and it freezes in that state .
Please find below the LINQ query for your reference:
" (From x In dtSelectDataTable.AsEnumerable() where Not (From a In dtSelectDataTable.AsEnumerable() Join b In dtExport.AsEnumerable() On a(“GUI”).ToString() Equals b(“User”).ToString() select a).Contains(x) select x).CopyToDataTable() "
From a In dtSelectDataTable.AsEnumerable() Join b In dtExport.AsEnumerable() On a(“GUI”).ToString() Not Equals b(“User”).ToString() select a).Contains(x) select x).CopyToDataTable()