Importing a CSV file into Azure SQL with Azure Functions

CSV To SQL

Importing CSV files into Azure SQL is quick and easy using Azure Functions. By utilising LinqToSQL, reading and serialising each line of the CSV into an IEnumerable of objects only takes a few lines of code. Start by creating an Azure Functions project in Visual Studio. I’m using Visual Studio 2019 and have ASP.NET Core … Read more

Azure Functions not showing all executions under Monitoring

Azure Functions Monitoring

I recently deployed a very simple Azure Functions 2.0 project from Visual Studio 2019 that contained a single timer triggered function. The function had a daily timer trigger and I noticed that there were gaps in the executions in the monitoring tab in the Azure portal. I went looking in the associated storage account tables … Read more

Preview a website before changing DNS without a temporary URL

DNS names

Setting up a new website on a new server or with a different hosting provider while the existing website is still live presents some challenges. Https configuration Firstly, to test https configurations configuration, you need to use the correct URL. Most hosting control panels supply a temporary URL, or you can alias your own spare … Read more

Implementing ASP.NET Core session with Redis Cache on Azure

Redic Cache

Using Redis cache in Windows Azure to save session state for an ASP.NET Core web app is quick and easy to configure. Create your Redis Cache in Azure Firstly, if you don’t have an Azure account create a Free Azure Trial Account. Once you’re logged into your Azure account, Click the + Create a resource … Read more

Azure Functions and Sentry in Visual Studio 2017

Sentry is a fantastic tool for error tracking in all kinds of applications, including Azure Functions. I focus primarily on the ASP.NET and ASP.NET Core stack and the integrations couldn’t be easier. I’m building out several Azure Functions projects at the moment in Visual Studio 2017 and wanted to incorporate Sentry to report on exceptions. … Read more

Adding a lookup field to an existing table using Entity Framework code first migrations

As you build out a site using the code first approach, at some point you will most likely need to add an additional lookup field to a class. There are a couple of steps required above what’s automatically done for you by EF code first migrations to make things work happily. If you consider the … Read more