Stores
.Select(x => new
{
City = x.City,
Location = x.Location,
Sales = Orders.Where(o => x.StoreID == o.StoreID && o.OrderDate.Month == 12).OrderBy(o => o.OrderDate.Day)
.Select (s => new
{
Date = s.OrderDate,
ProductSales = s.SubTotal,
GST = s.GST
})
}).Dump();
Stores
.Select(x => new
{
City = x.City,
Location = x.Location,
Sales = Orders.Where(o => x.StoreID == o.StoreID && o.OrderDate.Month == 12).OrderBy(o => o.OrderDate.Day)
.Select (s => new
{
Date = s.OrderDate,
ProductSales = s.SubTotal,
GST = s.GST
})
}).Dump();