CODEWITHSUNDEEP
c#.netlinq
Coder-Meca
Coder-Meca

Reputation: 409

DbExpressionBinding requires an input expression LINQ

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

Upvotes: 1

Views: 78

Answers (2)

Coder-Meca
Coder-Meca

Reputation: 409

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

Upvotes: 1

Fatemeh Mansoor
Fatemeh Mansoor

Reputation: 565

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);

Upvotes: 0

Related Questions