Getting ConnectionStrings config settings from appsettings.json

Question

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.

Set · Accepted Answer · 2018-04-25 06:42:59Z

1

Configuration API provides extension method for IConfiguration to simplify reading ConnectionStrings section:

// using Microsoft.Extensions.Configuration;

string connectionString = _config.GetConnectionString("myConnectionString");

what it does is return configuration?.GetSection("ConnectionStrings")?[name];

answered Apr 25, 2018 at 6:42

Set

50.1k23 gold badges138 silver badges153 bronze badges

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

Comments

simone.tino · Accepted Answer · 2018-04-24 22:44:18Z

0

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.

answered Apr 24, 2018 at 22:44

simone.tino

2,5314 gold badges34 silver badges46 bronze badges

3 Comments

Sam Over a year ago

Thank you! Using a colon fixed the issue. I also wanted to use the GetValue() method but for some reason, it's not available to me. See update in original post. Thank you again for your help.

simone.tino Over a year ago

The method lies in the Microsoft.Extensions.Configuration namespace. Are you using it? If not, then try and you should then be able to access it.

mitchellJ Over a year ago

It's in that namespace but it's actually an extension via Microsoft.Extensions.Configuration.Binder.

Collectives™ on Stack Overflow

Getting ConnectionStrings config settings from appsettings.json

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related