title: Entity Framework EF code first executing sproc using ExecuteStoreCommand is very slow
body: <p>I have a stored procedure in Azure sql db which when I run from SSMS it completes in about 300 ms.
  The sproc takes an id and a date range, collects some data and save it to an aggregation table. 
  It doesn't return any result.</p>
  
  <p>When it runs from EF code first ExecuteStoreCommand object (with the same parameters)
  it takes about 60 seconds to complete.</p>
  
  <p>I have tried to use context.Database.ExecuteSqlCommand and context.Database.SqlQuery
  as well with same results, very slow!</p>
  
  <p>Can someone please explain how is it that the EF execution is so slow compare to direct execution of the sproc?</p>
  
  <p>Is there any decent tool out there that can tell me what EF is doing (profiler?)</p>