Using the MSSQL 2016 "AT TIMEZONE" from Entity Framework?

How to use MSSQL 2016 function AT TIMEZONEfrom Entity Framework?

In other words, how to generate

SELECT MyTimestamp AT TIME ZONE 'Central European Standard Time' FROM MyTable

LINQ in entity structure? Is it still supported? Can I extend the Entity Framework manually for this feature?

It is always possible to create a database view with a timezone column, but ideally I would like to avoid this extra view.

+4
source share

Source: https://habr.com/ru/post/1661856/


All Articles