config.json - Adding database connection strings in ASP.NET vNext

Question

I am in the process of learning ASP.NET vNext. I need to store two connection strings in the config.json file. How do I store those? Can I do this:

config.json

{
  "connectionStrings" : {
    "connection-1" : "server=...",
    "connection-2" : "server=..."
  }
}

I have not been able to find a schema for config.json. For that reason, I wasn't sure how to do it. I saw the use of IConfiguration here. Still, I wasn't sure how Configuration was available in the app.

Victor Hurdugaci · Accepted Answer · 2015-01-09 08:34:55Z

6

This is the official Configuration repo and this is a great blog post explaining the configuration system.

Long story short:

You need one or more Microsoft.Framework.ConfigurationModel.* NuGet packages in your application. The list of available packages is here.
Add the configuration sources that you need
Build the config file(s)
Read the configuration sources

answered Jan 9, 2015 at 8:34

Victor Hurdugaci

28.5k5 gold badges90 silver badges103 bronze badges

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

4 Comments

xam developer Over a year ago

Thank you for sharing. How would you use this model on a class library though? From what I can see, I would have to re-instantiate an IConfiguration object in every single instance of a class in my class library. This seems inefficient. Please correct me if I'm wrong.

Victor Hurdugaci Over a year ago

You can inject IConfiguration or even hold a static reference to it somewhere...

xam developer Over a year ago

Thank you for your patience. Do you know of an example of IConfiguration getting injected? I'm slowly learning this stuff :)

Victor Hurdugaci Over a year ago

I wrote this article a while ago and except a few packages being renamed, it should be a good place to start with dependency injection in ASP.NET vNext blogs.msdn.com/b/webdev/archive/2014/06/17/…

BHR · Accepted Answer · 2015-12-07 04:47:20Z

2

Here is how you can do it:

 {   
      "Data": {
        "connection-1": {
          "ConnectionString": "Server=..."
        },
        "connection-2": {
          "ConnectionString": "Server=..."
        }   
}

}

edited Dec 7, 2015 at 4:47

answered Dec 7, 2015 at 4:02

BHR

1931 silver badge9 bronze badges

Comments

Chris Catignani · Accepted Answer · 2021-04-16 18:12:50Z

0

This is how it's done these days...

{
  "ConnectionStrings": {
    "myDb1": "Server=myServer;Database=myDb1;Trusted_Connection=True;",
    "myDb2": "Server=myServer;Database=myDb2;Trusted_Connection=True;"
  }
}

From: Store and read connection string in appsettings.json

answered Apr 16, 2021 at 18:12

Chris Catignani

5,30819 gold badges47 silver badges54 bronze badges

Collectives™ on Stack Overflow

config.json - Adding database connection strings in ASP.NET vNext

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related