Linq Error for Join

Hi Team,

Facing error for the written code.

Please help.

@yash.choursia can you give what is the input and expected output

LINQ Syntax is strict and allows not the Not Equals construct
We can rewrite to a match with ANY operator and can deny it

(From d1 in dt1.AsEnumerable
Let v = d1(“ColX”).toString.ToUpper.Trim
Let chk = dt2.AsEnumerable.Any(Function (d2) d2(“ColY”).toString.Trim.ToUpper.Equals(v))
Where not chk

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.