Question

帮我把这个sql语句改成linq select * from a where id not in (select id from b)

Answer 1

var query =
from _a in db.a
where !(from _b in db.b select _b.id).Contains(_a.id)
select _a;

Answer 2

var Query = from c in db.a
where c.id not in (from d in db.b select d)
select c;