Loading

How to use not equal in joining of LINQ

Asp.Net Hein

11y20.6k.NET

var h = (from l in EntityBroker.getEntity().trainings

group l by new { l.IDNo } into z

where z.Where(y => y.IDNo == z.Key.IDNo).Count() >= 1

join n in EntityBroker.getEntity().members on "Singapore Citizen" equals n.Nationality

select new { Idnumber = z.Key.IDNo });

You will see my example code... In this code I want to use ' not equal ' instead of equals.

Please don't say like "!="...... It cannot use in this statement.

Thanks a lot for viewing my question and give me the correct answer. :-)

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gobind Gupta9y ago
var query = (from t in _context.TableA

where !_context.TableB.Any(pv => pv.Id== t.Id)
select t).ToList();
Khan Abrar Ahmed11y ago
HI you can try "where", "except" or "exceptby" in you linq experession.