Query multiple filters from in memory filter object array [duplicate]

I have a filter class structure like this

public class SchemeInvestorDataDateFilter
{
    public int SchemeId { get; set; }
    public int InvestorId { get; set; }
    public DateTime Date { get; set; }
}

I am passing the list of this filter object to get the data from database using linq like this

var schemeIds = filters.Select(x => x.SchemeId);
var investorIds = filters.Select(x => x.InvestorId);
var dates = filters.Select(x => x.Date);

var query = Context.SchemeInvestorDataDates
        .Where(x =>
        schemeIds.Contains(x.SchemeInvestor.SchemeId) &&
        investorIds.Contains(x.SchemeInvestor.InvestorId) &&
        dates.Contains(x.Date) &&
        !x.IsDeleted
        );

Everything is working fine but this is not the correct way to do of what I exactly want.

I want it to filter the rows for the combination of schemeId + investorId + date

So basically it should return the rows which has this combination matching.

Currently it returns the rows of all permutation combination of passed schemeId, investorId and date.

This works because it returns all the records which suffice my condition but it is not the right way because it is returning some extra rows also which I do not want.

But I am not sure how can I write a query in link that checks this combination of in memory filter list for each DB Entity.

I know how to do it with Dapper but I am looking for a way using linq.

Is there a way even exist?

EDIT

This how this can be achieved using dapper. (Similar case as the above one)

StringBuilder query = new StringBuilder("select * from schemeinvestors si join (");

for (int i = 0; i < schemeInvestorIds.Count(); i++)
{
    var data = schemeInvestorIds.ElementAt(i);
    query.Append($"select {data.investorId} as InvestorId, {data.schemeId} as SchemeId");
    query.Append(schemeInvestorIds.Count() - 1 == i ? "" : " union ");
}

query.Append(") x on si.InvestorId=x.InvestorId and si.SchemeId=x.SchemeId");

using (var connection = BuildConnection())
{
    connection.Open();

    return await connection.QueryAsync<SchemeInvestor>(query.ToString());
}