How to write Is Not Select query VB.Net

Below is the code used to get where column 7 in p equals operation_id in q. However, I want to get data where “column7” in p IS NOT EQUAL TO “operation_id” in q and assign the value to a datatable variable.

How do I write it please?

(From p in mainSheetRead.Select() where( From q in ReadQuriosFile.Select() where q(“operation_id”).Equals(p(“Column7”)) Select q).ToArray.Count=1 Select p).ToArray.CopyToDataTable()

@Bukola
Give a try rewriting the statement with the help of Any / All as a LINQ statement

(From p in mainSheetRead.AsEnumerable 
where Not ReadQuriosFile.AsEnumerable.Any(Function (q) q(“operation_id”).toString.Trim.Equals(p(“Column7”).toString.Trim))
Select p).CopyToDataTable()