I have an ASP.NET Core app deployed in Azure App Service, with both staging and production deployment slots. Currently, the app uses a single Azure SQL Database connection string stored in Azure Key Vault.

In my Program.cs file, I retrieve the connection string as follows:

var sqlConnectionString = builder.Configuration.GetSection("sqlConnectionString").Value;

builder.Services.AddDbContext<MyAppContext>(options =>
    options.UseSqlServer(sqlConnectionString ?? throw new InvalidOperationException("Connection string 'MyAppContext' not found.")));

The sqlConnectionString is not stored in appsettings.json; it is fetched directly from the Key Vault.

I need to connect the production deployment slot to a different Azure SQL Database. This should ensure that when I swap slots, the production instance of the app connects to the production database.

I added a new Connection String named sqlConnectionString of type SQLAzure under the Environment Variables in the production slot settings. However, this did not work, and the production slot still connects to the staging database.