title: What's the difference between multiple where clauses and && operator in LINQ-to-SQL?
body: <p>It looks like I can write a <code>where x.a==1 &amp;&amp; x.b==1</code> as </p>
  
  <pre><code>where x.a==1
  where x.b==1
  </code></pre>
  
  <p>As I understand the latter turns into <code>.Where(x =&gt; x.a == 1).Where(x =&gt; x.b ==1)</code>, but how does this translate to DB? Which would be better in terms of optimization? I can always look at the executed query from profiler but that would hardly be a generalization but more like a single empirical observation, which I don't want to rely on.</p>
  
  <p>Going through System.Linq namespace with reflector is another option but then we would miss the chance to save many people from spending time on the same thing. I'll do it if I don't get any answers.</p>