LINQ To SQL exception: Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains operator

by

Replace the usages of Any with Contains in your query. eg:

searchTerms.Contains(c.Email)

This should get the result you’re looking for. It looks backwards, but it’s correct- it’ll generate an IN operator for each field inside a Contains with all the elements in searchTerms.

The AddressLine1 part won’t work this way- you’ll have to loop-generate the comparisons yourself with 

c.addressLine1.Contains(...)

Something like PredicateBuilder can be helpful for this.

More Related Contents:

  1. LINQ-to-SQL vs stored procedures? [closed]
  2. Linq: adding conditions to the where clause conditionally
  3. LINQ Between Operator
  4. LINQ across multiple databases
  5. Learning about LINQ [closed]
  6. How can I reject all changes in a Linq to SQL’s DataContext?
  7. LINQ with SQLite (linqtosql)
  8. How to create a dynamic LINQ join extension method
  9. LINQ not updating on .SubmitChanges()
  10. How to dynamically add OR operator to WHERE clause in LINQ
  11. Linq To Sql – Dynamic OrderBy – Case When
  12. Is there a pattern using Linq to dynamically create a filter?
  13. Linq to SQL how to do “where [column] in (list of values)”
  14. Multiple WHERE clause in Linq
  15. How do I write this cross apply query in LINQ-to-SQL?
  16. Point connectionstring in dbml to app.config
  17. Building Dynamic LINQ Queries based on Combobox Value
  18. NHibernate vs LINQ to SQL
  19. Returning IEnumerable vs. IQueryable
  20. Linq to Sql: Multiple left outer joins
  21. Entity framework linq query Include() multiple children entities
  22. Convert String to Int in EF 4.0
  23. Understanding .AsEnumerable() in LINQ to SQL
  24. Linq version of SQL “IN” statement
  25. LINQ Join with Multiple Conditions in On Clause
  26. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  27. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  28. EF 4: Removing child object from collection does not delete it – why?
  29. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  30. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”

Leave a Comment