How to configure connection string in Azure web app in .NET 8?

Question

I have a web application in .NET 8 hosted in an Azure web app.

I have added a connection string in environment variables and want to access it in the program.cs file when we normally pass the connection string to the DbContext class:

 var services = new ServiceCollection();
 builder.Services.AddDbContext<EmployeeDbContext>(options =>
        options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

I checked the same with copilot, it gave me this code, but it errors at:

builder.Configuration.AddAzureAppConfiguration();
builder.Configuration.Build();

-------------------

using Microsoft.Extensions.Configuration;
    
var builder = WebApplication.CreateBuilder(args);
    
// Add Azure App Configuration
builder.Configuration.AddAzureAppConfiguration(Environment.GetEnvironmentVariable("DefaultConnection"));
    
// Build the configuration
var config = builder.Configuration.Build();
    
// Access the connection string
string connectionString = config.GetConnectionString("YourConnectionStringName");

Edit

I have also tried this code, but I'm not able to get the connection string:

string connString = builder.Configuration.GetConnectionString("DefaultConnection");

builder.Services.AddDbContext<EmployeeDbContext>(options =>
    options.UseSqlServer(connString));

Due to this I am getting this error:

An unhandled exception occurred while processing the request. InvalidOperationException: The ConnectionString property has not been initialized.
Microsoft.Data.SqlClient.SqlConnection.PermissionDemand()

Help appreciated

marc_s · Accepted Answer · 2025-04-05 15:37:00Z

1

Values in Azure environment variables aren't part of "Azure App Configuration" - that's a separate service.

To get at a connection string defined in the Azure Environment Variables, you're already using the correct code:

// get your connection string from the Azure app service's 
// "Environment variables / Connection strings" settings
string connString = builder.Configuration.GetConnectionString("DefaultConnection");

// use connection string for your DbContext class
builder.Services.AddDbContext<EmployeeDbContext>(options =>
    options.UseSqlServer(connString));

edited Apr 5 at 15:37

answered Apr 5 at 15:16

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to configure connection string in Azure web app in .NET 8?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related