title: Linq to SQL any from Enumerable
body: <p>I'm working on a search engine for our application.
  The User should be able to find the item containing more words, or any of those words. The User can use "find where contains all words" or "find where contains any word".</p>
  
  <p>I am using C# 4.6.2 and LINQ to SQL.</p>
  
  <p>code is something like:</p>
  
  <pre><code>var words = userInput.Split(' '); // can be something like "Hi all"
  var result = selection.Where(q =&gt; words.Any(k =&gt; q.Name.Contains(k)));
  </code></pre>
  
  <p>In this case the user wants to find items that contain "Hi" or "all"</p>
  
  <p>When I try iterate through result, I get this exception:
  Local sequence cannot be used in LINQ to SQL implementations of query operators except the Contains operator</p>
  
  <p>Do you have any idea what is best approach?</p>
  
  <p>Thank you
  Jakub</p>