اسنیپت‌ها، ترفندها و کدهای کاربردی

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=MyAppDb;Trusted_Connection=True;MultipleActiveResultSets=true;TrustServerCertificate=True"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*"
}

// By password and id
"DefaultConnection": "Server=YOUR_SERVER;Database=MyAppDb;User Id=sa;Password=YourPassword;TrustServerCertificate=True"

// MySql
"DefaultConnection": "Server=localhost;Database=MyAppDb;User=root;Password=YourPassword"

// Program.cs
builder.Services.AddDbContext<AppDbContext>(options =>
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));