Question

mvc 在Ef中怎么是实现 where id not in()

select * from b where pid not in(select pid from c) 怎么用EF实现啊！！！

Answer 1

var b1s = from b in TableB
where ...

select b.B1;var c2s = from c in TableC
where ...

select c.C2;var a1sAndA2s = from a in TableA
where !b1s.Contains(a.A3)
&& c2s.Contains(a.A4)
select new {
a.A1,
a.A2
};

Answer 2

没有这个语法，但可以变通，示例代码：
int[] arr=new int[]{1,2,35,34,54,100};//示意，实际你肯定拿到了这些数据了，其它数据类型类似
//DbContext为EF上下文，b为你的表名pid为你的字段
var data=DbContext.b.Where(c=>arr.Contains(c.pid));//data即为所求