Tuesday, February 15, 2011

LINQ - Not In

Recently I had to do this query and the follwing showed me how to


var query =

from c in dc.Customers

where !(from o in dc.Orders

select o.CustomerID)

.Contains(c.CustomerID)

select c;


I took this from this link, Marco Russo's blog