problem with List.Contains lost some data
Posted: 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
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