title: Stored procedure is slow in Entity Framework
body: <p>I am calling a stored procedure (that returns data) from Entity Framework using the query below</p>
  
  <pre><code>from sp in db.GetSale(bID, SID,m,y).Where(x =&gt; x.isActive == true)
  select sp
  </code></pre>
  
  <p>If I run this procedure directly, it takes only 2 seconds, but when I call this stored procedure through EF, it is taking 10 to 15 seconds. </p>
  
  <p>Any guidance to improve the situation? I have seen other post here on SO but have no success</p>
  
  <p>Edit</p>
  
  <p>Here is sqlplan for my procedure
  <a href="https://skydrive.live.com/redir?resid=87DCBD5D3E9AAA57!374" rel="noreferrer">https://skydrive.live.com/redir?resid=87DCBD5D3E9AAA57!374</a></p>