Preparing the application for deployment

We're currently using PostgreSQL as our local development database, and although you can set up a Postgres database in Azure, it is far more expensive than running with SQL Server instead. This is why we chose to create a SQL Server and associated database when setting up the environment earlier. However, we now need to configure our application to work with multiple database providers, depending on the environment we are running in. We're also going to tweak the post-publish build steps that came preconfigured with the project template we started from. There are a couple of potential issues that can crop up when using Git to deploy to Azure, so we'll aim to combat them in advance to avoid headaches later on.

Configuring multiple database providers

Working with two different providers based on the environment we're running in might seem like a strange way of doing things. However, it is actually more common than you might think. Many development teams...