Missed opportunity for IN instead of EXISTS in ExecuteDelete
Open
area-perf
area-query
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- PR merge metrics
- PR metrics pending
Description
LINQ:
```c#
await ctx.Blogs
.Where(b => b.Posts.Any(p => p.Title == "foo"))
.ExecuteDeleteAsync();
```
SQL:
```sql
DELETE FROM [b]
FROM [Blogs] AS [b]
WHERE EXISTS (
SELECT 1
FROM [Post] AS [p]
WHERE [b].[Id] = [p].[BlogId] AND [p].[Title] = N'foo')
```
Contributor guide
Assessment
This issue has not been assessed yet.