求linq语句
SELECT * FROM a
WHERE id NOT IN
(SELECT id FROM b) LINQ select where
[解决办法]
from x in db.a
where !b.Select(y => y.id).Contains(x.id)
select x;
[解决办法]
var query=a.Where(x=>!b.Select(y=>y.id).Contains(x.id));
[解决办法]
var hs=new HashSet<int>(b.Select(y => y.id));
var query=a.Where(x=>!hs.Contains(x.id));