Is there anyway I could use nullable datetime property to get the year ?

Question

I am trying to perform the following linq to entities query-

var data = DataContext.Employee.Where(e=>e.Date.Year>1986).ToList();

Now the problem is that Date field is a nullable DateTime field and I can't access Year property and on the database side I can't change legacy code! ....anyways is there anyway possible to use the year property?

Answer 1

var data = DataContext.Employee
    .Where(e=>e.Date.HasValue && e.Date.Value.Year>1986).ToList();

Note that this will not include Employees without a date in the list.