List<A> a = (from p in Alist
where !(from f in Blist select f.Id).Contains(p.Id)
where !(from f in Blist select f.Id).Contains(p.Id)
select p).ToList();
查出来的sql语句为:select * from A where A.Id not in(select Id * from B)