from x in a
where !b.Any(y=>y.id==x.id)
select x
-------------------------------------
转化成的sql类似如下
SELECT [t0].[ID] AS [ID]
FROM [a] AS [t0]
WHERE NOT (EXISTS(
SELECT NULL AS [EMPTY]
FROM [b] AS [t1]
WHERE [t1].[ID] = [t0].[ID]
))
这样b表中没有的就输出了。
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024