Linq 实现 Sqlserver的 Exists
https://www.cnblogs.com/leftfist/p/6808651.html 参考博文地址
var query = from a in _T1.GetAll().Where(x => x.FlagDeleted == false) where _T1.GetAll().Where(x => x.ID.Equals(ID) && x.FlagDeleted == false) .Any(b => b.ID.Equals(a.ID) && b.No.Equals(a.No)) select a;
实现的Sql 语句就是
SELECT [x].* FROM [T1] AS [x] WHERE ([x].[FlagDeleted] = 0) AND EXISTS ( SELECT 1 FROM [T1] AS [x0] WHERE (([x0].[ID] = ID) AND ([x0].[FlagDeleted] = 0)) AND (([x0].[ID] = [x].[ID]) AND ([x0].[No] = [x].[No])))