Migrating DBFunctions from Entity Framework 6 to Entity framework Core

Question

I am migrating my .Net 6 Project from Entity framework 6 to Entity Framework Core and I need to replace the following code. How do I replace this Entity Framework 6 Sql TruncateTime Function with one that works with EF Core.

var result = db.Tickets
               .Where(x => DbFunctions.TruncateTime(x.DateTimeCreated) == statCalcDefinitionDateTime.Date)

If you care about indexes, you should not do such comparison. .Where(x => x.DateTimeCreated >= statCalcDefinitionDateTime.Date && x.DateTimeCreated < statCalcDefinitionDateTime.Date.AddDays(1)) should be enough. — Svyatoslav Danyliv
– Svyatoslav Danyliv, Commented Jun 22, 2022 at 13:34
Anyway, EF Core has translation of x.DateTimeCreated.Date to CONVERT(date, @dateTime), so just replace DbFunctions.TruncateTime(x.DateTimeCreated) with x.DateTimeCreated.Date but I recommend to use my first approach. — Svyatoslav Danyliv
– Svyatoslav Danyliv, Commented Jun 22, 2022 at 14:06
@SvyatoslavDanyliv Your advice to compare dates by range rather than equality is interesting. Why is it better? — lonix
– lonix, Commented Jul 11, 2024 at 13:54
@lonix, because range comparison uses Database Indexes, if they exists for sure. If you truncate to date they will be disabled and you will have table scan. I saw that for several casess SQL have optimizations for CONVERT(date, DateColumn) but I wouldn't hope for it. — Svyatoslav Danyliv
– Svyatoslav Danyliv, Commented Jul 11, 2024 at 16:04

BoMerican · Accepted Answer · 2022-06-24 20:07:29Z

4

As Svyatoslav Danyliv Said in the comments. Entity framework core now supports "DateTime.Date" so there is no longer a need for the "dbFunctions.TruncateTime()" function.

Svyatoslav Danyliv also suggested I used a range in my where statement instead of the date, and I would agree. Blow is the new Entity Framework Core way of "DBFunctions.TruncateTime()"

var result = db.Tickets
               .Where(x => x.DateTimeCreated.Date == statCalcDefinitionDateTime.Date)

Or alternatively you can use a date range

var result = db.Tickets
               .Where(x => 
                      x.DateTimeCreated >= statCalcDefinitionDateTime.Date && 
                      x.DateTimeCreated < statCalcDefinitionDateTime.Date.AddDays(1))

NOTE: I also found the same solution HERE

answered Jun 24, 2022 at 20:07

BoMerican

3103 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Migrating DBFunctions from Entity Framework 6 to Entity framework Core

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related