[EFCore 2.1] Exception Not supported type when using Contains
Posted: Fri 15 Jun 2018 16:17
Hello,
When I make a request with a Where using Contains like this:
var productIds = new decimal[]{1,2,3};
IQueryable<Product> query = _dataContext.Set<Product>();
return await query.Where(m => productIds.Contains(m..ProductId)).ToListAsync();
It throws an exception:
System.NotSupportedException: 'Not supported type 'System.Decimal[]' of the parameter '__productIds_0'.'
Configuration:
AspNetCore 2.1
EF Core 2.1
Devart.Data.Oracle.EFCore 9.5.527
When I make a request with a Where using Contains like this:
var productIds = new decimal[]{1,2,3};
IQueryable<Product> query = _dataContext.Set<Product>();
return await query.Where(m => productIds.Contains(m..ProductId)).ToListAsync();
It throws an exception:
System.NotSupportedException: 'Not supported type 'System.Decimal[]' of the parameter '__productIds_0'.'
Configuration:
AspNetCore 2.1
EF Core 2.1
Devart.Data.Oracle.EFCore 9.5.527