Resolved: Fetch rows from DB where multiple columns have to match supplied values in ef core

class MyClassDto
{
   public string Value1 { get; set; }
   public string Value2 { get; set; }
   public string Value3 { get; set; }
   public int Value4 { get; set; }
   public int Value5 { get; set; }
}

public IEnumerable<MyClassDb> GetData(IEnumerable<MyClassDto> data)
{
    _context.MyClassDb.Where(x => data.Contains(x.Value1) && data.Contains(x.Value2) && ...
}

public async Task< List<MyClassDb> > GetDataAsync( IEnumerable<MyClassDto> data, CancellationToken cancellationToken = default )
{
    if( data is null ) throw new ArgumentNullException(nameof(data));

    List<MyClassDb> list = new List<MyClassDb>();

    foreach( MyClassDto dto in data )
    {
        MyClassDb? single = await this.dbContext.MyClassDb
            .Where( m =>
                m.Value1 == dto.Value1 &&
                m.Value2 == dto.Value2 &&
                m.Value3 == dto.Value3 &&
                m.Value4 == dto.Value4 &&
                m.Value5 == dto.Value5
            )
            .SingleOrDefaultAsync( cancellationToken )
            .ConfigureAwait(false);

        if( single != null ) list.Add( single );
    }
    
    return list;
}

public async Task< List<MyClassDb> > GetDataAsync( IEnumerable<MyClassDto> data, CancellationToken cancellationToken = default )
{
    if( data is null ) throw new ArgumentNullException(nameof(data));

    var filter = PredicateBuilder.False<MyClassDb>();

    foreach( MyClassDto dto in data )
    {
        filter = filter.Or( m =>
            m.Value1 == dto.Value1 &&
            m.Value2 == dto.Value2 &&
            m.Value3 == dto.Value3 &&
            m.Value4 == dto.Value4 &&
            m.Value5 == dto.Value5
        );
    }

    return await this.dbContext.MyClassDb
        .Where( filter )
        .ToListAsync( cancellationToken )
        .ConfigureAwait(false);
}