SQL 的not in 怎么转化成LINQ ?泪奔求高手解答!!!!!
有高手吗
select * from QY_Business where BusinessID not in(select OtherBusinessID from QY_BusinessAssignConsumePlaceDetail)
var result=from u in db. QY_Business let n =QY_BusinessAssignConsumePlaceDetail.select(c=>c.OtherBusinessID ) where !n.Contains(u.BusinessID) select u;