appsettings.json connectionstrings code example

Example 1: ef core connection string sql server

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "RazorPagesMovieContext": "Server=(localdb)\\mssqllocaldb;Database=RazorPagesMovieContext-bc;Trusted_Connection=True;MultipleActiveResultSets=true"
  }
}

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

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

Example 3: 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;",
    }
  } 
}