title: Entity Framework Stored Procedures - Multiple Result sets with CodeFirst
body: <p>I am using the below code to get a regular result from a stored procedure:</p>
  
  <pre><code>var paramUserId = new SqlParameter
  {
      ParameterName = "userId",
      Value = userId
  };
  
  string query = string.Format("{0} {1}",
                "SpSetFoo",
                "@userId");
  
  var results = context.Database.SqlQuery&lt;FooModel&gt;(query,
                                               paramUserId);
  
  result = results.ToList();
  </code></pre>
  
  <p>Meanwhile I need to retrieve multiple result sets from another stored procedure, which I found it's possible according to this documentation : <a href="http://msdn.microsoft.com/en-us/data/jj691402.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/data/jj691402.aspx</a></p>
  
  <p>However the example from Microsoft is using ADO.NET. It's not possible to achieve the same result without ADO.NET using EF instead?</p>
  
  <p>Thanks</p>