ICollection<T> doesn't translate to SQL

[jirkafajfr]

When ICollection<T> is used in Where(...) it does not generate proper SQL query and crashes with request for query rewrite.

Steps to reproduce

I've created following repo https://github.com/jirkafajfr/EfCore-CollectionInExpressionProblem which demonstrates the problem. Essentially when ICollection<T> comes to the expression it can't be translated where array or list would work just fine.

Crashes

ICollection<int> ids = new List<int>
{
    1,
    2
};

_context.Blogs
    .Where(post => ids.Contains(post.BlogId))
    .Should()
    .NotBeEmpty();

System.InvalidOperationException : The LINQ expression 'Where<Blog>(
    source: DbSet<Blog>, 
    predicate: (b) => (Unhandled parameter: __ids_0).Contains(b.BlogId))' 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.

Works fine

var ids = new List<int>
{
    1,
    2
};

_context.Blogs
    .Where(post => ids.Contains(post.BlogId))
    .Should()
    .NotBeEmpty();

Notes

The attached repo demonstrates that this used to work in EfCore 2.2 but is not broken with EfCore 3.0

Further technical details

EF Core version: 3.0
Database provider: Microsoft.EntityFrameworkCore.Sqlite, Npgsql.EntityFrameworkCore.PostgreSQL
Target framework: .NET Core 3.0
Operating system: Windows 10, Linux (attached docker)
IDE: Visual Studio 2019 16.3

[ajcvickers]

Duplicate of #17342. Verified tests are passing with latest daily build.