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);