title: Multiple where clause in link separated with or
body: <p>I have the following scenario:</p>
  
  <p>A user can pick from any one of the following options during a search:</p>
  
  <ul>
  <li>0</li>
  <li>1-3</li>
  <li>4-6</li>
  <li>7-9</li>
  <li>10-12</li>
  <li>12+</li>
  </ul>
  
  <p>say they picked 0, 4-6 and 12+</p>
  
  <p>The SQL where statement would be:</p>
  
  <pre><code>Where (total_count = 0
  OR (total_count &gt;= 4 AND total_count &lt;= 6)
  OR total_count &gt; 12)
  </code></pre>
  
  <p>Now to get these values I am iterating through a checkbox list collection so was trying:</p>
  
  <pre><code>query = query.Where(tc =&gt; tc.total_count &gt;= 4 &amp;&amp; tc.total_count &lt;= 6);
  </code></pre>
  
  <p>But this was adding an AND between the statements, how could I add an or. I realise that I could potentially build a list with integers in and do a contains but I don't know how much the 12+ would potentially go up to.</p>
  
  <p>Thanks</p>