Hi,
The following Linq query fails with "The specified type member 'Date' is not supported in LINQ to Entities."
viewModel.InvoiceLessons = from ss in db.StudentSemesters
join l in db.Lessons on ss.Id equals l.StudentSemesterId
join cd in db.CalendarDates on l.Date.Date equals cd.Date
join t in db.Tariffs on l.TariffId equals t.Id
where ss.Id == id
select new PreliminaryInvoice {.....
};
>>> join cd in db.CalendarDates on l.Date.Date equals cd.Date
cd.Date = 7/7/2013
is to join with all lessons on that day
eg. l.Date = 7/7/2013 15:00, 7/7/2013 15:30, 7/7/2013 16:00
regards, Guy
Go to the complete details ...