title: how to get multiple resultsets using EF/Linq
body: <p>what is the best way to get multiple resultsets to my api using linq or EF</p>
  
  <p>as i have around 25 diffrent resultset 
  <a href="https://i.stack.imgur.com/CqCJX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CqCJX.png" alt="enter image description here"></a></p>
  
  <p>but i only get out the first resultset to swagger using </p>
  
  <pre><code>       [HttpGet]
         [Route("tire-tabel")]
         public List&lt;DeviationCalculation_Result&gt; TireTabel(decimal presentWidth, decimal presentAspectRatio, string presentRimSize, int maxDeviation)
                     {
                         using (var context = new OminiTireEntities())
                         {
                             String sql =
                             "SET NOCOUNT ON; " +
                             "EXEC [Tabel].[DeviationCalculation] " +
                             "@PresentWidth= '" + presentWidth + "', " +
                             "@PresentAspectRatio= '" + presentAspectRatio + "', " +
                             "@PresentInches= '" + presentRimSize + "', " +
                             "@MaxDeviation= '" + maxDeviation + "' ";
  
  
                             List&lt;SqlParameter&gt; sqlParams = new List&lt;SqlParameter&gt;();
                             sqlParams.Add(new SqlParameter("PresentWidth", (object) presentWidth ?? DBNull.Value));
                             sqlParams.Add(new SqlParameter("PresentAspectRatio", (object)presentAspectRatio ?? DBNull.Value));
                             sqlParams.Add(new SqlParameter("PresentInches", (object)presentRimSize ?? DBNull.Value));
                             sqlParams.Add(new SqlParameter("MaxDeviation", (object)maxDeviation ?? DBNull.Value));
                             var result = context.Database.SqlQuery&lt;DeviationCalculation_Result&gt;(sql).ToList&lt;DeviationCalculation_Result&gt;();               
  
  return result;
                         }
                     }
  </code></pre>