appsettings connection string 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: sql connection string in .net core

{
  "ConnectionStrings": {
    "BloggingDatabase": "Server=(localdb)\\mssqllocaldb;Database=EFGetStarted.ConsoleApp.NewDb;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;",
    }
  } 
}