ConnectionString in Asp.Net Core

[Henrique Duarte]

Can I use the ConnectionStrings in appsettings.Development.json/appsettings.Production.json?

Everytime I try todo so, the report  gives me an exception, but if if move the same exact ConnectionString to appsettings.json file, the report runs.

[Todor]

Hello Henrique,

You may check our updated articles on .NET Core applications:

• How To: Host Reports Service In ASP.NET Core 2.1 and 2.2
• How To: Host Reports Service In ASP.NET Core 3+

The following code assures that the project will use the default configuration file, and will respect the appSettings.{environment}.json file :

// otherwise instantiate the default builder which will use the default appSettings.json and appSettings.{environment}.json files.
var defaultBuilder = Microsoft.AspNetCore.WebHost.CreateDefaultBuilder()
    .Build();
return defaultBuilder.Services.GetService<IConfiguration>();

 

When the configuration file name is provided explicitly the connection string will be searched for in the exact file path specified. In this case, you may set the name for the configuration file conditionally, based on the environment, for example:

if (environment.IsDevelopment())
{
    configFileName = "appsettings.Development.json";
}
else
{
    configFileName = "appsettings.json";
}

var configFilePath = System.IO.Path.Combine(environment.ContentRootPath, configFileName);
return new ConfigurationBuilder()
                .AddJsonFile(configFilePath, true)
                .Build();

Regards,
Todor
Progress Telerik