SQL语句:
select * from QY_Business where StatusID=1 and BusinessID not in(select OtherBusinessID from QY_BusinessAssignConsumePlaceDetail where StatusID =1)
Linq语句:
var result = db.QY_Business.Where(c => c.StatusID == 1 &&!(from y in db.QY_BusinessAssignConsumePlaceDetailwhere y.StatusID == 1 select y.OtherBusinessID).Contains(c.BusinessID));