title: Entity framework running sprocs and native queries performance considerations
body: <p>I'm wondering if there's a performance penalty when doing the following vs using plain old ado.net DataReader and DataTable:</p>
  
  <pre><code>using(DBEntities dbEntities = new dbEntities)
  {
      ObjectResult&lt;tblCustomers&gt; customers =
          dbEntities.ExecuteStoreQuery&lt;tblCustomers&gt;("SELECT name,id FROM tblCustomers");
  }
  </code></pre>
  
  <p>I would also like to run sprocs using dbEntity.</p>
  
  <p>I mention this because i'm developing a highly performance sensitive application but would still like to use the entity framework.</p>
  
  <p>furthermore, can anyone point me to recent performance tests of linq to entities compiled queries on .net 4.0?</p>
  
  <p><strong>EDIT</strong><br>
  If i go with ado.net i plan on inserting the results i get from each row to a .net object manually. So it's entity framework storequery/sproc vs ado.net + manually creating and inserting data to a .net object.</p>