Join with local collection using TVP?

[smitpatel]

            var ids = new uint[] { 1, 2 };

            await AssertQueryScalar(
                async,
                ss => from e in ss.Set<Employee>()
                      join id in ids on e.EmployeeID equals id
                      select e.EmployeeID);

Above could be written as contains also. For tuples above syntax may help.

[smitpatel]

Related #17031

[roji]

Duplicate of #30426