Arrays (or any IEnumerable) cannot be parameterized


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?
Closed Apr 20, 2012 at 11:02 PM by mattwar


mattwar wrote Apr 20, 2012 at 11:02 PM

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 20, 2012 at 11:02 PM

wrote Feb 14, 2013 at 7:44 PM

wrote May 16, 2013 at 9:59 AM