Method 'Boolean Contains(System.String)' has no supported translation to SQL

Question

"Method 'Boolean Contains(System.String)' has no supported translation to SQL."

query is IsQueryable but this stopped working:

foreach (string s in collection1)
{
       if (s.Length > 0)
                {
                    query = query.Where(m => m.collection2.Contains(s));

                }
}

UPDATE: it works when i make query "ienumerable" instead of iqueryable. What would be the way to get same result using linq instead of iterating through loop?

Answer 1

Try this:

query = query.Where(m => m.collection2.ToList().Contains(s));
                                       ^^^^^^^^