protected override string GetConnectionString(ConfigEnvironment env)
{
return
($"Server={env.DatabaseHost.GetValueOrDefault("localhost")};" +
$"Port={env.DatabasePort.GetValueOrDefault(5432)};" +
$"Database={env.DatabaseName};" +
$"User Id={env.DatabaseUser};" +
$"Password={env.DatabasePswd};" +
$"Timeout={env.DatabaseTout.GetValueOrDefault(30)};" +
$"Command Timeout={env.DatabaseTout.GetValueOrDefault(120)};" +
$"ApplicationName={Assembly.GetEntryAssembly().GetName().Name}");
}
protected override string GetConnectionString(ConfigEnvironment env)
{
return(new StringBuilder()
.Append("Data Source=").Append(env.DatabaseHost.GetValueOrDefault("."))
.Append(",").Append(env.DatabasePort.GetValueOrDefault(1433)).Append(";")
.Append("Initial Catalog=").Append(env.DatabaseName.Value).Append(";")
.AppendIf(env.DatabaseUser.HasValue, "User Id=", env.DatabaseUser.Value, ';')
.AppendIf(env.DatabasePswd.HasValue, "Password="******"Integrated Security=True;")
.AppendIf((!env.DatabaseUser.HasValue && !env.DatabasePswd.HasValue), "Trusted_Connection=True;")
.Append("MultipleActiveResultSets=True;")
.Append("Connection Timeout=").Append(env.DatabaseTout.GetValueOrDefault(30)).Append(";")
.ToString());
}
public Builder UseEnvironmentVariables(ConfigEnvironment environment)
{
this.ConfigEnvironment = environment ?? throw new ArgumentNullException(nameof(environment));
return(this);
}
protected abstract string GetConnectionString(ConfigEnvironment env);
