LINQ: Entity string field contains any of an array of strings

by

Since you want to see if search contains a word which is contained in the description of p you basically need to test for each value in search if it is contained in the description of p

result = from p in products
           where search.Any(val => p.Description.Contains(val))
           select p;

This is c# syntax for the lambda method since my vb is not that great

More Related Contents:

  1. String Operation using Linq
  2. How to check if a string contains text from an array of substrings in JavaScript?
  3. How do I use LINQ Contains(string[]) instead of Contains(string)
  4. String contains any items in an array (case insensitive)
  5. Multiple “order by” in LINQ
  6. How to convert UTF-8 byte[] to string
  7. How to get character array from a string?
  8. How to access random item in list?
  9. Linq with group by having count
  10. Difference between char *str=”STRING” and char str[] = “STRING”?
  11. LINQ Between Operator
  12. Convert flat array to a delimited string to be saved in the database
  13. Find index of a value in an array
  14. LINQ OrderBy versus ThenBy
  15. What’s the difference between IQueryable and IEnumerable [duplicate]
  16. How to implement the Hashable Protocol in Swift for an Int array (a custom string struct)
  17. How to split a long string without breaking words?
  18. Linq-to-entities – Include() method not loading
  19. Convert javascript array to string
  20. conditional include in linq to entities?
  21. Easiest way to Rotate a List in c#
  22. Find substring in a list of strings
  23. How to parse a string and return a nested array?
  24. Expose IQueryable Over WCF Service
  25. PHP get values from SimpleXMLElement array
  26. How to implode array with key and value without foreach in PHP
  27. How to convert array values to lowercase in PHP?
  28. ASP.NET Core & EntityFramework Core: Left (Outer) Join in Linq
  29. How to implement Unit of Work that works with EF and NHibernate
  30. Where are string literals stored, and can I modify them?

Leave a Comment