SyntaxFix

[linq] The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties

Just use simple properties.

var tomorrow = currentDateTime.Date + 1;  
var eventsCustom = eventCustomRepository.FindAllEventsCustomByUniqueStudentReference(userDevice.UniqueStudentReference)
                            .Where(x =>  x.DateTimeStart >= currentDateTime.Date 
                                   and x.DateTimeStart < tomorrow);

If future dates are not possible in your app, then >= x.DateTimeStart >= currentDateTime.Date is sufficient.

if you have more complex date comparisons, then check Canonical functions and if you have EF6+ DB functions

More Generally - For people searching for issues Supported Linq methods in EF can explain similar issues with linq statements that work on Memory base Lists but not in EF.

Examples related to linq

• Async await in linq select • How to resolve Value cannot be null. Parameter name: source in linq? • What does Include() do in LINQ? • Selecting multiple columns with linq query and lambda expression • System.Collections.Generic.List does not contain a definition for 'Select' • lambda expression join multiple tables with select and where clause • LINQ select one field from list of DTO objects to array • The model backing the 'ApplicationDbContext' context has changed since the database was created • Check if two lists are equal • Why is this error, 'Sequence contains no elements', happening?

Examples related to entity-framework-4

• Entity Framework Join 3 Tables • Entity framework self referencing loop detected • The object 'DF__*' is dependent on column '*' - Changing int to double • LEFT JOIN in LINQ to entities? • Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths - why? • The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties • How to include a child object's child object in Entity Framework 5 • EF Migrations: Rollback last applied migration? • The specified type member is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported • How to show Alert Message like "successfully Inserted" after inserting to DB using ASp.net MVC3

Examples related to linq-to-entities

• How to add a default "Select" option to this ASP.NET DropDownList control? • LEFT JOIN in LINQ to entities? • How to get first record in each group using Linq • Linq to Entities join vs groupjoin • The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties • Linq where clause compare only date value without time value • The specified type member is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported • SQL to Entity Framework Count Group-By • LINQ to Entities does not recognize the method • The cast to value type 'Int32' failed because the materialized value is null