How to use “contains” or “like” in a dynamic linq query?

by

Here is the answer! The Dynamic Linq does support the . operator,

According to the docs:

“Instance field or instance property
access. Any public field or property
can be accessed.”

Thus, it is possible to use this syntax

.Where("MyColumn.Contains(@0)", myArray)

Thanks for all the suggestions! And thanks to me for finding the solution.

More Related Contents:

  1. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  2. LINQ to SQL Left Outer Join
  3. How do I get the MAX row with a GROUP BY in LINQ query?
  4. Why use LINQ Join on a simple one-many relationship?
  5. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  6. LINQ to Entities does not recognize the method
  7. Which method performs better: .Any() vs .Count() > 0?
  8. What is the difference between IQueryable and IEnumerable?
  9. How to do SQL Like % in Linq?
  10. LINQ – Left Join, Group By, and Count
  11. Case insensitive string compare in LINQ-to-SQL
  12. “Or” equivalent in Linq Where() lambda expression
  13. LINQ Single vs First
  14. Why does a Linq Cast operation fail when I have an implicit cast defined?
  15. EF LINQ include multiple and nested entities
  16. Operation could destabilize the runtime?
  17. How to select only the records with the highest date in LINQ
  18. Ignore namespaces in LINQ to XML
  19. DISTINCT() and ORDERBY issue
  20. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  21. Does LINQ work with IEnumerable?
  22. LINQ, can’t join to string
  23. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  24. Get sum of two columns in one LINQ query
  25. LinqToSql declare and instantiate DataContext best practice?
  26. Linq: What is the difference between Select and Where
  27. Linq to Objects: does GroupBy preserve order of elements?
  28. Do you think it’s advantageous to switch to Entity Framework? [closed]
  29. How to Convert Row to Column in Linq and SQL
  30. How to return a page of results from SQL?

Leave a Comment