SQL 的not in 怎么转化成LINQ ?泪奔求高手解答！！！！！

[zhanzkw]

有高手吗

select * from QY_Business where BusinessID not in(select OtherBusinessID from QY_BusinessAssignConsumePlaceDetail) 

怎么转化成Linq?

[threenewbee]

var query = QY_Business.Where(x => !QY_BusinessAssignConsumePlaceDetail.Contains(x.OtherBusinessID));

[EnForGrass]

var query = QY_Business.Where(x => !QY_BusinessAssignConsumePlaceDetail.Contains(x.BusinessID));

[threenewbee]

[Quote=引用 2 楼 的回复:]

C# code

var query = QY_Business.Where(x => !QY_BusinessAssignConsumePlaceDetail.Contains(x.BusinessID));
[/Quote]
这个对。我看错了。

[你的选择B]

var result=from u in db. QY_Business
           let n =QY_BusinessAssignConsumePlaceDetail.select(c=>c.OtherBusinessID )
           where !n.Contains(u.BusinessID)
           select u;