title: Entity Framework SQL Query Generation
body: <p>I am having difficulty understanding how Entity Framework generates a single SQL Query from a couple of Linq methods. Here is a code which selects Username from a table.</p>
  <pre><code>        var result1 = context.UserMasters
                               .Where(t =&gt; t.UserRole == &quot;LOCAL&quot;)
                               .Skip(100)
                               .Take(100)
                               .Select(t =&gt; new { t.UserName }); 
  </code></pre>
  <p>Typically the above code is identical to the below code.</p>
  <pre><code>        var test = context.UserMasters.Where(t=&gt; t.UserRole == &quot;LOCAL&quot;);
          test = test.Skip(100);
          test = test.Take(100);
          var result2 = test.Select(t =&gt; new { t.UserName });
  </code></pre>
  <p>I hope we can get results from the table after any Linq Method. So there is a list readily available always. Is it selecting all results from the table initially and doing operation on the list ?</p>