EF core 3 global query filter cannot translate contain expression

[dimz87]

In the EF Core version 2.2 i can create a query filter with contain as the filtering expression, in the version 3.0 it will throw exception that showing it cannot be translated.

Steps to reproduce

In the db context class create an entity with query filter

protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
          
            base.OnModelCreating(modelBuilder);
modelBuilder.Entity<Company>().HasQueryFilter(c =>
          _companyCodes.Contains(c.Code));
}

The filter will always produce exception:

The LINQ expression 'Where<Company>( source: DbSet<Company>, predicate: (c) => (Unhandled parameter: __ef_filter__p_0) || (Unhandled parameter: __ef_filter___companyCodes_1).Contains(c.Code))' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to either AsEnumerable(), AsAsyncEnumerable(), ToList(), or ToListAsync(). See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

As it is located in the queryfilter i cannot use asasyncenumberable or to list, how to mitigate this issue in ef 3 ?

Further technical details

EF Core version: 3.0
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: .NET Core 3.0
Operating system: Windows 10
IDE: Visual Studio 2019 16.3.5

[smitpatel]

What is the type of _companyCodes?

[dimz87]

The _companyCodes type is List<string>

[smitpatel]

Could be duplicate of #17342
Can you try running with 3.1-preview1 package?

[dimz87]

Putting List<string> into ICollection<string> or IList<string> causing this issue, i can confirm on version 3.1 preview using List<string> directly the problem solved.

[smitpatel]

@dimz87 - can you share a small repro code which demonstrate the issue?

[dimz87]

@dimz87 - can you share a small repro code which demonstrate the issue?

Sorry, i have clarify my comment, pleas see my comment