title: how to handle store procedure return one to many Relationship
body: <p>i have a store procedure get table Category and Produce 
  this is my entity</p>
  
  <pre><code>public class Category
      {
          public long Id { get; set; }
          public string Name { get; set; }
          public List&lt;Product&gt; Products { get; set; }
      }
  
      public class Product
      {
          public long Id { get; set; }
          public long CategoryId { get; set; }
          public string Name { get; set; }
      }
  </code></pre>
  
  <p>and this is my store procedure</p>
  
  <pre><code>CREATE PROCEDURE GetCategoryAndProductByCategoryId
      @Id int
  AS
  BEGIN
      SET NOCOUNT ON;
  
      SELECT * from Category as c
      inner join Product on c.Id = p.CategoryId
      where c.Id = @Id
  END
  GO
  
  
  public virtual ObjectResult&lt;Category_Result&gt; GetCategoryAndProductByCategoryId(Nullable&lt;int&gt; Id)
          {
              var IdParameter = Id.HasValue ?
                  new ObjectParameter("Id", Id) :
                  new ObjectParameter("Id", typeof(System.Int32));
  
  
              return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction&lt;Category_Result&gt;("GetCategoryAndProductByCategoryId", IdParameter);
          }
  </code></pre>
  
  <p>how can i map to one Category and list Product Because store Product always return list object, i mean Category is list Object. how can i Bind it to Category</p>