1

Closed

Arrays (or any IEnumerable) cannot be parameterized

description

It is not possible to parameterize an array, or any IEnumerable. Therefore any query that uses AConstantArray.Contains(...) cannot be usefully compiled or used in the query cache.
 
Please could this be made possible?
 
Thanks!
Closed Apr 21, 2012 at 12:02 AM by mattwar

comments

mattwar wrote Apr 21, 2012 at 12:02 AM

Constant arrays used in Contains are not parameterizable because they are embedded into the query as constants. Therefore each query that has a different array must correspond to a different cached query.

wrote Apr 21, 2012 at 12:02 AM

wrote Feb 14, 2013 at 8:44 PM

wrote May 16, 2013 at 10:59 AM