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])))