Linq Error for Join

[yash.choursia]

Hi Team,

Facing error for the written code.

Please help.

[Dinesh_Guptil]

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

[ppr (Peter)]

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
…).ToList