NH-3786 - Error on parameters list with Any() in LINQ

[nhibernate-bot]

Ehsan Zeynali created an issue — 5th May 2015, 5:07:28:

I need to run this query :

    var filterList = new List<string> { "1" , "2" } ;
    
    var q = SessionInstance.Query<Book>().Where(x => filterList.Any(s => s.StartsWith(x.Code)));
    var list = q.ToList();

But it has exception by this message : Specified method is not supported.

StackTrace :

at NHibernate.Hql.Ast.ANTLR.PolymorphicQuerySourceDetector.GetClassName(IASTNode querySource)
   at NHibernate.Hql.Ast.ANTLR.PolymorphicQuerySourceDetector.Process(IASTNode tree)
   at NHibernate.Hql.Ast.ANTLR.AstPolymorphicProcessor.Process()
   at NHibernate.Hql.Ast.ANTLR.ASTQueryTranslatorFactory.CreateQueryTranslators(IASTNode ast, String queryIdentifier, String collectionRole, Boolean shallow, IDictionary`2 filters, ISessionFactoryImplementor factory)
   at NHibernate.Hql.Ast.ANTLR.ASTQueryTranslatorFactory.CreateQueryTranslators(IQueryExpression queryExpression, String collectionRole, Boolean shallow, IDictionary`2 filters, ISessionFactoryImplementor factory)
   at NHibernate.Engine.Query.QueryPlanCache.GetHQLQueryPlan(IQueryExpression queryExpression, Boolean shallow, IDictionary`2 enabledFilters)
   at NHibernate.Impl.AbstractSessionImpl.GetHQLQueryPlan(IQueryExpression queryExpression, Boolean shallow)
   at NHibernate.Impl.AbstractSessionImpl.CreateQuery(IQueryExpression queryExpression)
   at NHibernate.Linq.DefaultQueryProvider.PrepareQuery(Expression expression, IQuery& query, NhLinqExpression& nhQuery)
   at NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression)
   at NHibernate.Linq.DefaultQueryProvider.Execute<TResult>(Expression expression)
   at Remotion.Linq.QueryableBase`1.GetEnumerator()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList<TSource>(IEnumerable`1 source)

---

Alexander Zaytsev added a comment — 5th May 2015, 7:27:17:

<~zeynali> what is intended SQL?

[bahusoid]

Seems such queries can be rewritten to make per parameter check. Something like: Where(x => (filterList[0].StartsWith(x.Code) || filterList[1].StartsWith(x.Code) || ...)