title: Using Generic Repository and Stored Procedures
body: <p>I am working on an existing application the uses the Generic Repo pattern and EF6 database first.
  I am calling a stored proc that returns a complex type that is not an existing entity in my entity models and therefore I am not sure what type to give. </p>
  
  <p>This is how my sp is being called from my service layer</p>
  
  <pre><code>_unitOfWork.Repository&lt;Model&gt;()
              .SqlQuery("sp_Get @FromDateTime, @ToDateTime, @CountyId",
                           new SqlParameter("FromDateTime", SqlDbType.DateTime) { Value = Request.FromDateTime },
                           new SqlParameter("ToDateTime", SqlDbType.DateTime) { Value = Request.TripToDateTime },
                           new SqlParameter("CountyId", SqlDbType.Int) { Value = Convert.ToInt32(Request.County) }
             ).ToList();
  </code></pre>
  
  <p>Do I create an Entity in my data layer to map to or what is the best approach for stored procedures returning complex types.
  If so is there custom mapping needed or is it just a case of creating the Entity class</p>
  
  <p>thank you</p>