_dbEntities.EmployeeAttendances.Where(x => x.DailyDate.Date.Equals(DateTime.Now.Date)).ToList();
"The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported."
How can i do this get employees data on based on current date in linq query?
EntityFramework cannot convert
DateTime.Date to SQL. So, it fails to generate expected SQL. Instead of that you can use
EF version) method if you want to get
Date part only:
_dbEntities.EmployeeAttendances .Where(x => EntityFunctions.TruncateTime(x.DailyDate) == DateTime.Now.Date) .ToList();
EntityFunctions methods are called canonical functions. And these are a set of functions, which are supported by all Entity Framework providers. These canonical functions will be translated to the corresponding data source functionality for the provider. Canonical functions are the preferred way to access functionality outside the core language, because they keep the queries portable.
As of EF6
EntityFunctions has been deprecated for
Dont use EntityFunctions in EF 6. TruncateTime is in the DbFunctions class: