How to get all records from thisa year onwards from LINQ to SQL model?

Question

Can anyone tell me an efficient way of returning this. I have:

var allPrices = site.Prices.AsQueryable();

I now want to query allPrices from current year onwards.

Thanks

Answer 1

var allPricesFiltered = allPrices.Where(p => p.Date.Year >= DateTime.Now.Year);

Answer 2

var currYear = DateTime.Now.Year;
var pricesAfterCurrYear = allPrices.Where(p => p.Date.Year >= currYear);