Getting error when using DbFunctions to truncate DateTime

Question

I'm trying to get a data filtering only by date (truncating the time). The field in database is DateTime.

As reference, I tried this solution that didn't work: 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported where I should use the EntityFunctions that was replaced by DbFunctions, however, It still didn't work.

So I searched more trying to find some code that looks like mine, and then I've found this other link: Using DbFunctions I get error: The specified type member 'Date' is not supported in LINQ to Entities but I'm still getting the same error:

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

Any suggestion?

My code:

var data = DateTime.Now.Date;
PostVisualizacoes visualizacao = db.PostVisualizacoes.Where(v => v.UsuId == usuario.UsuId && v.PosId == post.PosId && DbFunctions.TruncateTime(v.PosVisData.Date) == data).FirstOrDefault();

i think truncating you have to make outside , not in Enfw – Rahul Chaudhari Feb 15 '16 at 15:12 — Rahul Chaudhari, Feb 15 '16 at 15:12

ocuenca · Accepted Answer · 2016-02-15T15:30:33.037

You can avoid that exception if you remove the .Date call from your PosVisData property:

var data = DateTime.Now.Date;
PostVisualizacoes visualizacao = db.PostVisualizacoes.Where(v => v.UsuId == usuario.UsuId && v.PosId == post.PosId
                                                              && DbFunctions.TruncateTime(v.PosVisData) == data)
                                                     .FirstOrDefault();

Extract the date part from a DateTime property is the job of TruncateTime static method.

Getting error when using DbFunctions to truncate DateTime

1 Answers1