//not in linq
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
1 var xx=(from c in measStateDetail where !((from d in breakInstr select d.InstrCode).Contains(c.InstrCode)) select c).ToList()
//not in ef
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
1 listSP= query1.Where(m => !query2.Contains(m.ETPRS_CODE)).ToList();
//not in linq
1 var xx=(from c in measStateDetail where !((from d in breakInstr select d.InstrCode).Contains(c.InstrCode)) select c).ToList()
//not in ef
1 listSP= query1.Where(m => !query2.Contains(m.ETPRS_CODE)).ToList();
转载于:https://www.cnblogs.com/zj19940610/p/9228806.html