Author

.NET 5 System.Drawing

Note: The System.Drawing namespace is not recommended for new development, because it’s not supported within Windows services, ASP.NET Core, and ASP.NET. Attempting to use System.Drawing classes within one of these application types may result in run-time exceptions and diminished service performance. Recommended alternatives include ImageSharp, SkiaSharp, and Windows Imaging Components. On Windows, System.Drawing depends on the GDI+ native library, which is shipped as part... » read more

CRUD Operations

CRUD = Create, Read, Update and Delete In computer programming, create, read, update, and delete (CRUD) are the four basic operations of persistent storage.

Azure Storage Queue

Azure Queue Storage is a service for storing large numbers of messages. You access messages from anywhere in the world via authenticated calls using HTTP or HTTPS. A queue message can be up to 64 KB in size. A queue may contain millions of messages, up to the total capacity limit of a storage account.... » read more

Azure Function Get Environment Variable using local.settings.json

To get an environment variable or an app setting value, use System.Environment.GetEnvironmentVariable, as shown in the following code example: local.settings.json Note: Microsoft recommends this method because it works both locally with local.settings.json and in Azure. App settings can be read from environment variables both when developing locally and when running in Azure. When developing locally,... » read more

Run Timer Triggered Azure Function Locally

Gets or sets a value indicating whether the function should be invoked immediately on startup. After the initial startup run, the function will be run on schedule thereafter. Sources: https://stackoverflow.com/questions/46556621/what-is-the-simplest-way-to-run-a-timer-triggered-azure-function-locally-once

Reference System.Data.SqlClient not found

Microsoft has removed System.Data.SqlClient from the default installation of Visual Studio (.NET Core). In order to use it, you must install from NuGet as install-package System.Data.SqlClient.  Once installed, this reference is available for use and code will compile. Sources: https://social.msdn.microsoft.com/Forums/en-US/ec2361a3-1931-4423-bf68-08b206ce67aa/reference-systemdatasqlclient-not-found?forum=netfxbcl

Azure SQL: Recover Deleted Records

Via Azure Portal, restore a copy of the database from a backup at specific point in time. Via SSMS, copy over deleted records from recovered database back to the original database. Note: In Azure Portal, go to the original database and select “Retore”. Select a point in time before the accidental delete occurred. Time is... » read more

Always On Automatic Failover Jobs

In addition to the automatic failover that occurs for Always On setup, these jobs also needs to be created on both the Primary and the Secondary server to help with the automatic failover. In the event of a failover, all user jobs should be disabled on the Secondary server and enabled on the Primary server... » read more