title: LINQ: Entity string field contains any of an array of strings
body: <p>I want to get a collection of Product entities where the product.Description property contains any of the words in a string array. </p>
  
  <p>It would look something like this (result would be any product which had the word "mustard OR "pickles" OR "relish" in the Description text):</p>
  
  <pre><code>Dim products As List(Of ProductEntity) = New ProductRepository().AllProducts
  
  Dim search As String() = {"mustard", "pickles", "relish"}
  
  Dim result = From p In products _
       Where p.Description.Contains(search) _
       Select p
  
  Return result.ToList
  </code></pre>
  
  <p>I already looked at <a href="https://stackoverflow.com/questions/194930/how-do-i-use-linq-containsstring-instead-of-containsstring" title="this question">this similar question</a> but couldn't get it to work.</p>