title: Linq To Sql 'Where Or' operator
body: <p>I need to create a query which checks if a field (string) contains one or more words supplied at run time.</p>
  
  <p>Basically I need to be able to ask a WhereOr question.  This seems like it should be a common issue when dealing with LinqToSql.</p>
  
  <p>I found the following <a href="http://refactormycode.com/codes/1097-generic-linq-where-clause-oring-together-many" rel="noreferrer">reference</a> but can't make sense out of it - and have no idea how to use it in my project.</p>
  
  <p>i've tried the following loop:</p>
  
  <pre><code>        var query = from d in context.Domains select d;
          for (int i = 0; i &lt; words.Length; i++)
          {
              query = query.Where(d =&gt; d.Name.Contains(words[i]));
          }
  </code></pre>
  
  <p>but this builds a SQL query with <em>WHERE AND</em> Clauses NOT <em>Where OR</em></p>