title: how to get count Of Product according Store
body: <p>I have three Table : <code>Product</code> and <code>StoreDetail</code>  , <code>Store</code>
  <code>Store</code> Table holds <code>storeName</code> .
  I want get count of product according storeName , to do this I use belowe code :</p>
  
  <pre><code> var stocksQuery = storeDetails.GroupBy(row =&gt; new { row.StoreId, row.ProductId }).AsQueryable();
  
          List&lt;StockStatusViewModel&gt; result = new List&lt;StockStatusViewModel&gt;();
          foreach (var item in stocksQuery)
          {
              result.Add(new StockStatusViewModel
              {
                  Quantity = item.Sum(row =&gt; row.Quantity),
                  ProductCombinationId = item.Key.ProductAttributeCombinationId,
                  StoreId = item.Key.StoreId,
                  // here I need productName and StoreName
              });
  
          }
  </code></pre>
  
  <p>but I need to storeName and ProductName , how can I get these ?
  here Is my classes:</p>
  
  <pre><code> public class StoreDetail 
  {
      public Product Product{ get; set; }
      public  Guid ProductId { get; set; }
   }
  
   public class Product{
   public  ICollection&lt;StoreDetail&gt; StoreDetails { get; set; }
      }
  </code></pre>