Getting ConnectionStrings config settings from appsettings.json

debugcn Published at Dev

Sam

In my repository class, I have my Config object and looks like my connection string is under:

Config > Providers > Microsoft.Configuration.Json.JsonConfigurationProvider > Data > ConnectionStrings.myConnectionString

This is what my appsettings.json looks like:

{
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Warning"
    }
  },
  "ConnectionStrings": {
    "myConnectionString": details..."
  }
}

I'm trying to read myConnectionString as follows which is not working:

var cs = _config.GetSection("ConnectionStrings.myConnectionString").value;

What am I doing wrong?

UPDATE: For some reason, I'm not seeing GetValue() method. I'm using ASP.NET Core 2.0.

smn.tino

The issue seems to lie in the string path you are passing to the GetSection() method. According to the ASP.NET Core Configuration documentation you should use "ConnectionStrings:myConnectionString" instead of "ConnectionStrings.myConnectionString".

Plus, if you wish to retrieve the value directly you may prefer to use the GetValue() method instead:

var cs = _config.GetValue("ConnectionStrings:myConnectionString", "");

If you prefer, you can also use the index notation as:

var cs = _config["ConnectionStrings:myConnectionString"];

But I honestly find the first approach more clean and elegant as the GetValue() method allows you to specify a default value in case the property is not found in the configuration.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-08-10

Comments

0 comments

From Dev

Related Related

Article

Getting ConnectionStrings config settings from appsettings.json

Getting ConnectionStrings config settings from appsettings.json

How to move EF6.1 connection string from connectionStrings to an appSettings config file section?

MVC 3 getting values from AppSettings in web.config

Getting value from appsettings.json in .net core

Json in Web.Config AppSettings

How to create a JSON string with key/value pairs from web.config appsettings?

.NET Core 3.1 loading config from appsettings.json for console application

Override array settings in appsettings.json with those in appsettings.Production.json

Read file attribute from appsettings from web.config

Getting settings object from the buildscript

Access connection string from (ARM Template) WebSite.json OR override Web.config with ARM Template Settings

web.config connectionStrings on production server

How to get keys and values from Appsettings of Config file in Linq

Access appSettings in web.config from Thread in Class Library project

Using appSettings key from web.config in NavigateUrl property

Bind list of string from appsettings.json

Unable to read details from appsettings.json

Configuration classes from appsettings.json

Retrieving data from appsettings.json

WCF channelfactory with settings from the config file?

Reading settings from app.config or web.config in .NET

Backbone and best practice getting config JSON

getting setting from web.config in sitecore

getting send grid credentials from web config

Getting a parameter from a config file in FreeBSD

Getting variables From a config file to the browser

Getting JSON from PHP

Getting JSON from Form

Getting JSON from Form

Getting JSON from PHP