Query: Translate Exists #9295
Description
var query = db.Blogs.FirstOrDefault(b => b.Posts.Any(p => p.Name == "test"));Translate to
SELECT TOP(1) [b].[Id]
FROM [Blogs] AS [b]
WHERE EXISTS (
SELECT 1
FROM [Post] AS [p]
WHERE ([p].[Name] = N'test') AND ([b].[Id] = [p].[BlogId]))But
var query = db.Blogs.FirstOrDefault(b => b.Posts.Exists(p => p.Name == "test"));client evals. 🤦♂️