Lambda表达式帮助
|
我有一个问题如何写一个lambda表达式，我在这样的mssql查询中工作：
SELECT KUNDNR
FROM halldb.dbo.KUND
wWHERE NOT EXISTS
(
SELECT KundID
FROM halldb.dbo.KundInfo
WHERE KUNDNR = CONVERT(Varchar(50), KundInfo.KundID)
)
ORDER BY KUNDNR
db.KUNDs.Select(x => x).Except(db.KundInfos.Select(x => x));
db.KUNDs.Select(x => x.KUNDNR).Except(db.KundInfos.Select(x => x.KundID.ToString()));
没有找到相关结果
已邀请:
1 个回复
伐教爸
db.KUNDs.Where(k => !db.KundInfos.Any(ki => k.KUNDNR == ki.KundID.ToString())) .OrderBy(k => k.KUNDNR);