GetConnectionString using IHostBuilder

Question

(using .NET 6.0)

I used these commands to set a connection string:

dotnet user-secrets init
dotnet user-secrets set ConnectionStrings:AppConfig "{myconnectionstring}"

but I can't figure out how to retrieve that connection string using IHostBuilder. This returns a null string:

public class Program
{
    public static void Main(string[] args)
    {
        CreateHostBuilder(args).Build().Run();
    }

    private static IHostBuilder CreateHostBuilder(string[] args) => Host.CreateDefaultBuilder(args).ConfigureWebHostDefaults(webBuilder =>
    {
        webBuilder.ConfigureAppConfiguration((hostingContext, configurationBuilder) =>
            {
                configurationBuilder.AddAzureAppConfiguration(options =>
                {
                    var azureAppConfigConnectionString = hostingContext.Configuration.GetConnectionString("AppConfig");

Is your app .NET Core 6 WebApp or a Console App?

Harshitha Veeramalla
– Harshitha Veeramalla

2023-10-03 17:10:16 +00:00
Commented Oct 3, 2023 at 17:10 — Harshitha Veeramalla
– Harshitha Veeramalla, Commented Oct 3, 2023 at 17:10

Harshitha Veeramalla · Accepted Answer · 2023-10-04 11:32:08Z

0

Even Iam getting the user secret value null with the code which you have provided.

I am able to retrieve the user secret with few changes.

Thanks @Christian Nagel for the code snippet.

Add configurationBuilder.Build(); and then retrieve the value from the variable.

My Program.cs file

using Microsoft.AspNetCore.Hosting;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.Hosting;
using Microsoft.Extensions.Configuration.AzureAppConfiguration;
using System;

public class Program
{
   public static void Main(string[] args)
   {
       CreateHostBuilder(args).Build().Run();
   }

   private static IHostBuilder CreateHostBuilder(string[] args) =>
       Host.CreateDefaultBuilder(args)

           .ConfigureWebHostDefaults(webBuilder =>
           {
               webBuilder.ConfigureAppConfiguration((hostingContext, configurationBuilder) =>
               {
                   var mysettings = configurationBuilder.Build();
                   var azureAppConfigConnectionString = mysettings.GetConnectionString("AppConfig");

                   configurationBuilder.AddAzureAppConfiguration(options =>
                   {
                       options.Connect(azureAppConfigConnectionString);                              
                   });
               })
               .UseStartup<Startup>();
           });
}

Output:

enter image description here

edited Oct 4, 2023 at 11:32

answered Oct 4, 2023 at 11:26

Harshitha Veeramalla

9,4082 gold badges15 silver badges22 bronze badges

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

1 Comment

MikeSteigerwald Over a year ago

Many thanks! var mysettings = configurationBuilder.Build(); was what I was missing.

Collectives™ on Stack Overflow

GetConnectionString using IHostBuilder

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related