This question is locked. New answers and comments are not allowed.
Hello,
using LINQ-to-SQL for an Oracle database, the following fails if itemIds contains more than 1000 elements:
This is because Oracle does not support more than 1000 elements in a "WHERE ... IN (...)" clause.
I believe Telerik should handle this case internally, because building a working query is difficult from code. For example, OR-ing several Contains() calls with expression builders, or even using Oracle-specifing clauses that can handle this.
Here are some variations of queries that make this possible: post on StackOverflow.
Thanks,
Matej
using LINQ-to-SQL for an Oracle database, the following fails if itemIds contains more than 1000 elements:
context.Items.Where(i => itemIds.Contains(i.IdItem)).ToList()
This is because Oracle does not support more than 1000 elements in a "WHERE ... IN (...)" clause.
I believe Telerik should handle this case internally, because building a working query is difficult from code. For example, OR-ing several Contains() calls with expression builders, or even using Oracle-specifing clauses that can handle this.
Here are some variations of queries that make this possible: post on StackOverflow.
Thanks,
Matej