Page 1 of 1

problem with List.Contains lost some data

Posted: Wed 02 Sep 2015 06:47
by McMlok
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

Re: problem with List.Contains lost some data

Posted: Wed 02 Sep 2015 13:45
by Shalex
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.

Re: problem with List.Contains lost some data

Posted: Thu 10 Sep 2015 15:14
by Shalex
The new (8.5.492) build of dotConnect for Oracle is available for download: http://forums.devart.com/viewtopic.php?f=1&t=32423.