title: How to perform word search using LINQ?
body: <p>I have a list which contains the name of suppliers. Say</p>
  
  <pre><code>SuppId   Supplier Name
  ----------------------------------
  1        Aardema &amp; Whitelaw
  2        Aafedt Forde Gray
  3        Whitelaw &amp; Sears-Ewald
  </code></pre>
  
  <p>using following LINQ query </p>
  
  <pre><code>supplierListQuery = supplierListQuery.Where(x =&gt; x.SupplierName.Contains(SearchKey));
  </code></pre>
  
  <p>I can return records correctly in the following conditions,</p>
  
  <p>1) If i am using search string as <strong>"Whitelaw &amp; Sears-Ewald"</strong> it will return 3rd record.</p>
  
  <p>2) If i am using <strong>"Whitelaw"</strong> or "<strong>Sears-Ewald"</strong> it will return 3rd record.</p>
  
  <p>But how can i return 3rd record if i am giving search string as <strong>"Whitelaw Sears-Ewald"</strong>. It always returns 0 records. </p>
  
  <p>Can i use ALL to get this result, but i dont know how to use it for this particular need.</p>