EntityFramework Multiple Where : <p>I am wondering, if I use multiple <code>Where(...)</code> methods one after the other, is EntityFramework smart enough to combine it in a resulting query. Let's say I have:</p>

<pre><code>context.Items
    .Where(item =&gt; item.Number &gt; 0)
    .Where(item =&gt; item.Number &lt; 5)
    .ToList();
</code></pre>

<p>Will the resulting SQL query be the same as if I write:</p>

<pre><code>context.Items
    .Where(item =&gt; item.Number &gt; 0 &amp;&amp; item.Number &lt; 5)
    .ToList();
</code></pre>

<p>Are there any behind-the-scenes optimizations for multiple Where clause?</p>
