Linq-to-EF DateTime.ToLocalTime not supported

Question

DateTime.ToLocalTime is not supported in Linq to EF.

What's the alternative? I am running out of idea.

Answer 1

Instead of using .ToLocalTime() inside your Linq query, use the opposite conversion outside of the query on the parameters.

var dateUniversal = dateParam.ToUniversalTime();

var query = myTable.Where( t => t.DateTime > dateUniversal );