how to use connection string in appsettings.json code example

Example 1: how to define connection string in appsettings.json

{
  "Modules": {
    "Logging": {
      "logDb": "Server=myServer;Database=myDb1;Trusted_Connection=True;",
    },
    "Tenants": {
      "tenantsDb": "Server=myServer;Database=myDb1;Trusted_Connection=True;",
    }
  } 
}

Example 2: how to get connection string value from appsettings.json in .net core

string logDbConnectionString = _configuration.GetValue<string>("Modules:Logging:logDb"); // read logDb connection string example
string tenantsDbConnectionString = _configuration.GetValue<string>("Modules:Tenants:tenantsDb"); // read tenantsDb connection string example

Tags:

Sql Example