CODEWITHSUNDEEP
c#.netentity-frameworkentity-framework-6
GibboK
GibboK

Reputation: 73898

Using DbFunctions I get error: The specified type member 'Date' is not supported in LINQ to Entities

Using EF 6 when I run this code even using DbFunctions.TruncateTime

var touches = analyticRepo.GetAll()
                          .Where(x => DbFunctions.TruncateTime(x.DateCreated.Date) == report.DateCreated.Date);
var test = touches.ToList();

I get this error:

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

Any idea how to solve this.

Upvotes: 0

Views: 1923

Answers (1)

D Stanley
D Stanley

Reputation: 152491

You can pull the date up into a variable:

var reportDate = report.DateCreated.Date;
var touches = analyticRepo.GetAll()
                          .Where(x => DbFunctions.TruncateTime(x.DateCreated) == reportDate);
var test = touches.ToList();

Upvotes: 2

Related Questions