CODEWITHSUNDEEP
linq
Asaf David
Asaf David

Reputation: 3693

how would you query this in linq?

lets say i have 2 tables: products (just product ID and name) and sales (sale ID, product ID, amount, date)

now, given a start date and end date, i want to sum for every product its total sales amount in the given time frame notice that naturally some products will just have zero sales

how should i write this query?

Upvotes: 0

Views: 102

Answers (1)

eglasius
eglasius

Reputation: 36037

var products = 
    from p in mycontext.Products
    select new
    {
       Product = p,
       Sales = p.Sales
          .Where(s=>s.StartDate > startDate && s.EndDate < endDate)
          .Sum(s=>s.amount)
    }

Upvotes: 3

Related Questions