title: How to execute SP using Entity Framework code-first approach?
body: <p>I did some research in internet to know how to execute Stored Procedure using Entity Framework code-first approach. But i did not get any clear idea. Everybody is telling their own way of executing SP. In some blogs they have mentioned to execute in the following way and in other they have mentioned in a traditional ADO.NET way.</p>
  
  <pre><code>DbContext.Database.SqlQuery&lt;ProcedureResult&gt;("sp_TestProcedure @param1, @param2",param1val, param2value);
  </code></pre>
  
  <p>please let me know what is the appropriate way to execute SP. I am using MVC3, Entity FW code-first approach. Thanx</p>