DbExpressionBinding requires an input expression LINQ-CodePudding

I have tried this query :

var a  = (from q in dtResult
          from p in q.Proposition
          where motsClesInclureEt.All(word => p.Libelle.Contains(word))
          select q);

But I have an error :

DbExpressionBinding requires an input expression with a collection ResultType. Nom du paramètre : input

Note that dtResult of type IQueryable<Question> and p is of type ICollection<Proposition>and this an array of strings motsClesInclureEt

CodePudding user response：

The error because i'am passing motsClesInclureEt that is words with , char , i have change it with motsClesInclureEtSplit and it works !

CodePudding user response：

try adding .ToList()

var a  = (from q in dtResult.ToList()
      from p in q.Proposition
      where motsClesInclureEt.All(word => p.Libelle.Contains(word))
      select q);