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
problem with List.Contains lost some data
Re: problem with List.Contains lost some data
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
The new (8.5.492) build of dotConnect for Oracle is available for download: http://forums.devart.com/viewtopic.php?f=1&t=32423.