[EFCore 2.1] Exception Not supported type when using Contains

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
stephane.saquet
Posts: 1
Joined: Fri 15 Jun 2018 15:47

[EFCore 2.1] Exception Not supported type when using Contains

Post by stephane.saquet » 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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: [EFCore 2.1] Exception Not supported type when using Contains

Post by Shalex » Wed 20 Jun 2018 07:08

We have reproduced this issue with EF Core 2.1 and are investigating it.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: [EFCore 2.1] Exception Not supported type when using Contains

Post by Shalex » Mon 25 Jun 2018 11:24

The issue is fixed in the new (9.6.540) build of dotConnect for Oracle.

Post Reply