Connection String

SQL Server

!!! note "Valid SSL certificate"
- Use a comma to specify a port number with SQL Server: mycomputer.test.xxx.com,1234
- It's not necessary to specify an instance name when specifying the port.

AppSettings

"ConnectionStrings": {
      "DBConnection": "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;Encrypt=True;TrustServerCertificate=False;"
}

!!! note "Valid SSL certificate"
- Make sure the SQL Server uses a valid SSL certificate: - Get a Valid SSL Certificate
- Assign the Certificate to SQL Server: SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER (or instance name) > Right-click "Properties" > Certificate tab
- Enable Force Encryption (Optional but Recommended): SQL Server Configuration Manager > under Protocols for MSSQLSERVER > Right-click > Properties > Under the Flags tab, set Force Encryption to Yes

Program.cs

//Configure DB Context
//----------------------------------------
builder.Services.AddDbContext<DBContext>(options =>
{
    options.UseSqlServer(builder.Configuration.GetConnectionString("DBConnection"));
});

PostgreSQL

AppSettings

"ConnectionStrings": {
  "DBConnection": "User ID=postgres;Password=***;Host=localhost;Port=5432;Database=DB1;Pooling=true;"
}

Program.cs

//Configure DB Context
//----------------------------------------
builder.Services.AddDbContext<DBContext>(options =>
{
    options.UseNpgsql(builder.Configuration.GetConnectionString("DBConnection"));
}, ServiceLifetime.Scoped);