List.Contains does not work with List<object>

[steffibreuer]

Hello,

i'd like to create a query which filters by a List<object> in EFCore 3.1.3. This was working before in EFCore 2.2.6.

Steps to reproduce

Filtering by a List<object> throws an InvalidOperationException.

var itemIds = new List<object> { Guid.NewGuid() };
var items = await context.Item
    .Where(p => itemIds.Contains(p.ItemId))
    .ToListAsync();

System.InvalidOperationException: Null TypeMapping in Sql Tree
Stack Trace:
SqlTypeMappingVerifyingExpressionVisitor.VisitExtension(Expression node)
Expression.Accept(ExpressionVisitor visitor)
ExpressionVisitor.Visit(Expression node)
InExpression.VisitChildren(ExpressionVisitor visitor)
ExpressionVisitor.VisitExtension(Expression node)
SqlTypeMappingVerifyingExpressionVisitor.VisitExtension(Expression node)
Expression.Accept(ExpressionVisitor visitor)
ExpressionVisitor.Visit(Expression node)
RelationalSqlTranslatingExpressionVisitor.Translate(Expression expression)
RelationalQueryableMethodTranslatingExpressionVisitor.TranslateExpression(Expression expression)
RelationalQueryableMethodTranslatingExpressionVisitor.TranslateLambdaExpression(ShapedQueryExpression shapedQueryExpression, LambdaExpression lambdaExpression)
RelationalQueryableMethodTranslatingExpressionVisitor.TranslateWhere(ShapedQueryExpression source, LambdaExpression predicate)
QueryableMethodTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
RelationalQueryableMethodTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
MethodCallExpression.Accept(ExpressionVisitor visitor)
ExpressionVisitor.Visit(Expression node)
QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
Database.CompileQuery[TResult](Expression query, Boolean async)
QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
<>c__DisplayClass12_01.<ExecuteAsync>b__0() CompiledQueryCache.GetOrAddQueryCore[TFunc](Object cacheKey, Func1 compiler)
CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func1 compiler) QueryCompiler.ExecuteAsync[TResult](Expression query, CancellationToken cancellationToken) EntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken) EntityQueryable1.GetAsyncEnumerator(CancellationToken cancellationToken)
ConfiguredCancelableAsyncEnumerable1.GetAsyncEnumerator() EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable1 source, CancellationToken cancellationToken)

When i change the List type to Guid it works.
As this is only a simplified sample code changing the List type is not a prefereable option.

var referencedIds = new List<Guid> { Guid.NewGuid() };
var items = await context.Item
    .Where(p => itemIds.Contains(p.ItemId))
    .ToListAsync();

Further technical details

EF Core version: 3.1.3
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: netcoreapp3.1
Operating system: Windows 10
IDE: Visual Studio 2019 16.4

[LouLeGrain]

Hello, i encountered the exact same error, in the same context with EF Core 8.0.6.

I made a small repo for reproduction here

We found a workaround to type the list we were using with reflection, but i thought I'll let you know.

[ajcvickers]

@LouLeGrain I filed #33928 to track this.