Loading Hangfire configuration from appsettings.json in ASP.NET CORE web app

Question

I'm trying to use Hangfire with SQL Server, reading the connection string from the appsettings.json file. It doesn't work. Only when I provide the connection string to the UseSqlServerStorage method, does it work.

Here's appsettings.json:

{
  "ConnectionStrings": {
    "HangfireDemo": "Data Source=VSQL64;Initial Catalog=HangfireDemo;Integrated Security=SSPI;"
  },
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Debug",
      "System": "Information",
      "Microsoft": "Information"
    }
  }
}

And here the line that configures Hangfire in Startup.ConfigureServices:

services.AddHangfire(configuration => configuration.UseSqlServerStorage("Data Source=VSQL64;Initial Catalog=HangfireDemo;Integrated Security=SSPI;"));

If I write "HangfireDemo" in the UseSqlServerStorage method, it doesn't work. Only the full connection string in this method works.
How can I provide just the connection string name?

Joe Audette · Accepted Answer · 2016-08-07 13:55:01Z

6

you should be able to do it something like this:

public Startup(IHostingEnvironment env)
{
    var builder = new ConfigurationBuilder()
        .SetBasePath(env.ContentRootPath)
        .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true)
        .AddJsonFile($"appsettings.{env.EnvironmentName}.json", optional: true);


    builder.AddEnvironmentVariables();
    Configuration = builder.Build();

}


public IConfigurationRoot Configuration { get; }

public void ConfigureServices(IServiceCollection services)
{
    services.AddHangfire(configuration => 
    configuration.UseSqlServerStorage(Configuration.GetConnectionString("HangfireDemo"))
    );  

}

answered Aug 7, 2016 at 13:55

Joe Audette

37.1k12 gold badges111 silver badges103 bronze badges

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

Collectives™ on Stack Overflow

Loading Hangfire configuration from appsettings.json in ASP.NET CORE web app

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