EF Core 10 Contains hero (source of efcore10-contains.png)

ids.Contains(o.Id) · 8 IDs

The same LINQ, two different SQL answers.

EF CORE 9

1 JSON parameter

@__ids_0 = N'[1,2,…,8]'
IN (SELECT … OPENJSON(@__ids_0))

EF CORE 10

10 parameters, padded

@ids1

@ids2

@ids3

@ids4

@ids5

@ids6

@ids7

@ids8

@ids9

@ids10

@ids9 and @ids10 repeat the 8th value

EF Core 10.0.12 · SQL Server 2022 · past 2,098 values: one JSON parameter again

gdhami.net