c# - Linq query DateTime.Date.DayOfWeek

Question

Trying to get only Thursdays of 1 year back

using (var context = new Context1())
{
      // Get 1 year back only Thursday
      var oneYearEarlier = DateTime.Now.AddYears(-1);

      var query = (from c in context.Daily25Data
                   where c.Date > oneYearEarlier && c.Date.DayOfWeek == DayOfWeek.Thursday
                   select c).ToList();

      Console.WriteLine(query);
}

and getting

Additional information: The specified type member 'DayOfWeek' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

Answer 1

This is a clever solution using EntityFunctions.DiffDays

from his post:

DateTime firstSunday = new DateTime(1753, 1, 7); 
var bookings = from b in this.db.Bookings 
               where EntityFunctions.DiffDays(firstSunday, b.StartDateTime) % 7 == 1 
               select b;