title: LINQ (L2E) with stored procedure and IQueryable
body: <p>Consider a normal Linq expression will be something like this:<br>
  (This is just a sample to make things more understandable)</p>
  
  <pre><code> IQueryable&lt;Person&gt; personQuery= (from ppl in PersonContext  
                        select ppl).ASQueryable();
  
  
  List&lt;Person&gt;personList = personQuery.where(x =&gt; x.age==13).ToList();
  </code></pre>
  
  <p>So if I decided to put the 1st part of the linq query inside a stored procedure,<br>
  things will work out something like this.</p>
  
  <pre><code> IQueryable&lt;Person&gt; personQuery= PersonContext.sp_RetrievePerson().ASQueryable();
  
   List&lt;Person&gt; personList = personQuery.where(x =&gt; x.age==13).ToList();
  </code></pre>
  
  <p>So for the question, I believe that the 1st method only sends the sql call when toList() is called.<br>
  In another words, the query sent to sql for execution will be</p>
  
  <pre><code>Select * from Person where age=13
  </code></pre>
  
  <p>But for method 2, how many times will this query be sent for execution?<br>
  If it is only sent 1 time, does it make it redundant to call the stored procedure as stored procedure is known for having a faster execution and how will the query sent to sql look like?</p>