gistfile1.txt

using Microsoft.Data.SqlClient; // NuGet: Microsoft.Data.SqlClient

public static class SqlServerConnString
{
public static string Build(
string server,
int port,
string database,
string username,
string password,
bool trustServerCertificate = true,
bool encrypt = true)
{
var builder = new SqlConnectionStringBuilder();

// server,port format for SQL Server TCP
builder.DataSource = server + "," + port;
builder.InitialCatalog = database;

builder.UserID = username;
builder.Password = password;

builder.Encrypt = encrypt;
builder.TrustServerCertificate = trustServerCertificate;

// Optional common settings
builder.ConnectTimeout = 15;
builder.MultipleActiveResultSets = true; // MARS

return builder.ConnectionString;
}

public static string BuildIntegratedSecurity(
string server,
int port,
string database,
bool trustServerCertificate = true,
bool encrypt = true)
{
var builder = new SqlConnectionStringBuilder();

builder.DataSource = server + "," + port;
builder.InitialCatalog = database;

builder.IntegratedSecurity = true;

builder.Encrypt = encrypt;
builder.TrustServerCertificate = trustServerCertificate;

return builder.ConnectionString;
}
}



————///



using MySqlConnector; // NuGet: MySqlConnector

public static class MySqlConnString
{
public static string Build(
string host,
int port,
string database,
string username,
string password,
bool useSsl = true)
{
var builder = new MySqlConnectionStringBuilder();

builder.Server = host;
builder.Port = (uint)port;
builder.Database = database;

builder.UserID = username;
builder.Password = password;

// SSL/TLS options (pick what matches your environment)
builder.SslMode = useSsl ? MySqlSslMode.Required : MySqlSslMode.None;

// Optional common settings
builder.ConnectionTimeout = 15;
builder.DefaultCommandTimeout = 30;
builder.Pooling = true;

return builder.ConnectionString;
}
}