LINQ to Entities Join on DateTime.DayOfWeek

LINQ to SQL

var dayOfWeekCondition = (dt => dt.DayOfWeek == dayOfWeek);

LINQ to Entities

int dow = (int)dayOfWeek + 1; // SQL Day of week
var dayOfWeekCondition = (dt => SqlFunctions.DatePart(“weekday”, dt) == dow);

---

Source:

http://blog.abodit.com/2009/07/entity-framework-in-net-4-0/