How can we use ToLocalTime() in Entity Framework query?

Question

I save the date in the database as utc.

Code:

var result = _context.Tables
                     .OrderBy(x => x.UTCDate.ToLocalTime())
                     .ToList();

We need to see your code segment so we can better understand what it is you're attempting to do — devlin carnate, May 19 '21 at 15:52
`var result = _context.Tables .OrderBy(x=>x.UTCDate.ToLocalTime()) .ToList();` @Robert Harvey — beta, May 19 '21 at 15:54
That ordering should still work the way you expect it to if you just use `.OrderBy(x => x.UTCDate)` — Robert Harvey, May 19 '21 at 16:39
If you need to convert the dates to local time, you can update the objects in `result` after it's been populated from the database. — devlin carnate, May 19 '21 at 16:59

score 1 · Answer 1 · answered May 19 '21 at 16:01

1

Entity framework needs to translate your query into SQL

It cannot translate a c# function to SQL That is why you cannot use that

answered May 19 '21 at 16:01

David Edel

1 Answers1