public DbConnection(PostgreConfiguration sqlServerConfiguration)
{
Host = sqlServerConfiguration.HostName;
Port = sqlServerConfiguration.PortNumber;
Username = sqlServerConfiguration.User;
Password = sqlServerConfiguration.Password;
DbName = sqlServerConfiguration.DatabaseName;
}
public static PostgreConfiguration CreateConfiguration(string connectionString)
{
if (me == null)
{
lock (padlock)
{
me = new PostgreConfiguration(connectionString);
}
}
return(me);
}
public static NpgsqlConnection OpenConnection()
{
var connectionString = PostgreConfiguration.GetConnectionString(
serverName: Environment.GetEnvironmentVariable("POSTGRES_SERVERNAME"),
database: Environment.GetEnvironmentVariable("POSTGRES_DATABASE"),
userId: Environment.GetEnvironmentVariable("POSTGRES_USERID"),
password: Environment.GetEnvironmentVariable("POSTGRES_PASSWORD"));
var conn = new NpgsqlConnection(connectionString);
conn.Open();
return(conn);
}
private DbConnection CreateConnectionToPostGre(string connectionString)
{
var oracleConfiguration = PostgreConfiguration.CreateConfiguration(connectionString);
return(new DbConnection(oracleConfiguration));
}
