How do I filter by several columns simultaneously without creating a temporary table?

[voroninp]

I have a join table

public sealed record DemographicsInPeriod(int DemographicsId, int PeriodId)
{
    public int Id { get; private set; }
}

And I have a collection of pairs (periodId, demographicsId).

Is there a way to filter the result set by both values?

[roji]

That's not currently possible - it may end up being implemented as part of #31237 (though that's more about CLR complex types, and not necessarily about collections of value tuples).

In the meantime you can use dynamic expression generation to integrate your tuple collection as a series if ORs (though that would prevent query caching for variable numbers of collections), or use raw SQL to do something e.g. with OPENJSON.

[voroninp]

What do you think? Worth creating separate feature request?

[roji]

Duplicate of #11799

[roji]

@voroninp I think I found the specific issue - #11799. I've made a note on #31237 to take that into account.

I'll go ahead and close this as a dup of that, but let me know if you think anything is missing etc.