public static string ToPgsqlConnectionString(this DBSettings dbSettings)
{
var builder = new NpgsqlConnectionStringBuilder
{
Username = dbSettings.DBUserName,
Host = dbSettings.Server,
Password = dbSettings.DBPassword,
Database = dbSettings.Database,
CommandTimeout = 200,
ConnectionIdleLifetime = 30,
Pooling = true,
KeepAlive = 30,
TcpKeepAlive = true
};
if (dbSettings.Port != null)
{
builder.Port = dbSettings.Port.Value;
}
return(builder.ToString());
}
public DbConnectionSettings(DBSettings dbSettings)
{
_dbSettings = dbSettings;
}