Filter records by collection of parameter sets

[hubert-wojtowicz]

I am looking for solution described in more detail here here.

What I want to acheive is to generate query like:

SELECT *
FROM Entity
WHERE ( SomeId_1 = SomeId AND DateAt_1 = DateAt)
    OR..
    OR (SomeId_N = SomeId AND DateAt_N = DateAt)

using LINQ extension methods over IQuerable<Entity> interface, for Entity having collumns (among others) SomeId, DateAt.

Lets assume I have:

class SomeIdAtPair
{
   public int SomeId { get;set; }
   public DateTime DateAt { get;set; }
}

and collection of parameters:

var pairs = new List<SomeIdAtPair>
{
    new SomeIdAtPair { ... },
    ...
};

Is it possible or will it be possible in EF Core 3.1+?

[smitpatel]

Duplicate of #19070