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.

Accepted Answer

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 );
```

Solution