What is the SQL WHERE equivalence in lambda expressions?

Question

Here is what I have:

decimal sum = _myDB.Products.Sum(p => p.Price).GetValueOrDefault();

I also have two dates: DateTime start, DateTime end
I want to get the sum of all product prices between the beginning and the end, but I can not figure out how to turn on the variables in the equation lambda.

How do you include variables in the lambda equation to give it some specifications?

Answer 1

Use Enumerate. Where

decimal sum = _myDB.Products
                   .Where(p => (p.Date >= start) && (p.Date <= end) )
                   .Sum(p => p.Price)
                   .GetValueOrDefault();

Answer 2

 decimal sum = _myDB.Products
.Where(p => p.Start >= mystartDate && p.End <= myenddate)
.Sum(p => p.Price)

Sorry my syntax. But hopefully you have an idea.

EDIT: Fixed after Reid's suggestion.
Old code (incorrect)

 decimal sum = _myDB.Products
.Sum(p => p.Price)
.Where(p => p.Start >= mystartDate && p.End <= myenddate)

Answer 3

_myDB.Products
.Where(p => p.start >= "somevalue")
.Where(p => p.end <= "somevalue")
.Sum(p => p.Price).GetValueOrDefault();