problem with List.Contains lost some data

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
McMlok
Posts: 26
Joined: Tue 04 Jun 2013 13:01

problem with List.Contains lost some data

Post by McMlok » Wed 02 Sep 2015 06:47

Hello,

I have LINQ query where I use construct like list<int>.Contains(someId) when in list is many items (more than 1000) in SQL statement are generated few section someId in (....) connected with OR. Problem is that some ids is lost. I look to generated SQL and see some think like this someId in (....., 7, 8, 9, 10) OR someId (12, 13, 14 ....)

For workaround I did paging on my side. But can anybody look at it?

Thanks

Martin

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

Re: problem with List.Contains lost some data

Post by Shalex » Wed 02 Sep 2015 13:45

The bug with skipping every thousandth element in the SQL query generated by Entity Framework 6 is fixed. We will notify you when the corresponding build of dotConnect for Oracle is available for download.

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

Re: problem with List.Contains lost some data

Post by Shalex » Thu 10 Sep 2015 15:14

The new (8.5.492) build of dotConnect for Oracle is available for download: http://forums.devart.com/viewtopic.php?f=1&t=32423.

Post Reply