Fixes #37216

Description

EF 10 made important improvements around the translation of parameterized collections (docs): when a parameter collection is used, rather than sending it as a JSON array (which resulted in performance issues), we now inline it as a set of parameters into the SQL. Unfortunately, the SQL construct for this (VALUES) does not support empty sets, leading to a query failure when the parameterized collection is empty.

Customer impact

Queries making use of parameterized collections with any LINQ operator (other than Contains) fail when that collection happens to be empty:

List<int> ids = [];
_ = await context.Blogs.Join(ids, b => b.Id, ids => ids, (b, ids) => b).ToListAsync();

How found

Multiple customers reported on 10.0.0

Regression

Yes

Testing

Added

Risk

Very low, very small, targeted fix for the precise problematic case. Quirk added just in case.