LinqToEntities 查询没有连接的记录
我有 TableA 列出采购订单。我有 TableB 列出入库货件。每条装运记录都引用一个采购订单。我想要的是一个 LinqToSql 子句，它将返回 TableA 中尚未发货的采购订单记录。在 SQL 中这很简单：
SELECT * FROM Orders WHERE OrderID NOT IN (SELECT OrderID FROM Shipments).
I have TableA listing purchase orders. I have TableB listing Inbound Shipments. Each shipment record references a purchase order. What I want is a LinqToSql clause that will return those purchase order records from TableA that are not yet on a shipment. In SQL this would be simple:
SELECT * FROM Orders WHERE OrderID NOT IN (SELECT OrderID FROM Shipments).
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
试试这个http://introducinglinq.com/blogs/marcorusso/archive/2008/01/14/the-not-in-clause-in-linq-to-sql.aspx
try this http://introducinglinq.com/blogs/marcorusso/archive/2008/01/14/the-not-in-clause-in-linq-to-sql.aspx
假设 DbSet 称为 PurchaseOrders 和 Shipments，那么类似这样的内容就足够了：
Assuming DbSets called PurchaseOrders and Shipments then something like this should suffice: