DbExpressionBinding requires an input expression LINQ

Viewed 65

I have tried this query :

var a  = (from q in dtRe
          from p in q.Pro
          where motsE.All(word => p.Title.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<uio> and p is of type ICollection<prop>and this an array of strings motsCt

2 Answers

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

try adding .ToList()

var a  = (from q in dtRe.ToList()
      from p in q.Pro
      where WordEt.All(word => p.Title.Contains(word))
      select q);
Related