Azure

Entity Framework, Azure SQL, DateTime.Now, and Time Zones

January 25, 2022 in Entity Framework Azure Micro Post
Read Time: 3 minutes
Entity Framework, Azure SQL, DateTime.Now, and Time Zones
The Problem Imagine one day you wake up to reports from customers saying that their trial accounts have expired too early. How much earlier? About six (6) hours. First of all, you ask yourself why would they wait till the last few hours of a 30-day trial, but I digress. You load up your developer environment and get to work. The Set-Up You’re using Entity Framework to get all the expired accounts from your Azure SQL Server database so that you can deactivate them (made up scenario, but bear with me):
Read more...