static string buildpostgresqlconnectionstringfromobject(postgresqlconnectionstringdto _connectionstringdto)
{
string CONNECTION_STRING = @"Server=" + _connectionstringdto.datasource + ";" +
"Database=" + _connectionstringdto.database + ";" +
"Port=" + _connectionstringdto.port + ";" +
"User Id=" + _connectionstringdto.userid + ";" +
"Password=" + _connectionstringdto.password;
return(CONNECTION_STRING);
}
public static string getdefaultpostgresqlconnectionstring()
{
postgresqlconnectionstringdto _connectionstringdto = new postgresqlconnectionstringdto();
_connectionstringdto.datasource = System.Configuration.ConfigurationManager.AppSettings["postgresql_datasource"];
_connectionstringdto.database = System.Configuration.ConfigurationManager.AppSettings["postgresql_database"];
_connectionstringdto.userid = System.Configuration.ConfigurationManager.AppSettings["postgresql_userid"];
_connectionstringdto.password = System.Configuration.ConfigurationManager.AppSettings["postgresql_password"];
_connectionstringdto.port = System.Configuration.ConfigurationManager.AppSettings["postgresql_port"];
_connectionstringdto.update_schema_temp_db = System.Configuration.ConfigurationManager.AppSettings["update_schema_temp_db"];
_connectionstringdto.new_database_name = System.Configuration.ConfigurationManager.AppSettings["update_schema_temp_db"];
_connectionstringdto.update_schema_current_db = System.Configuration.ConfigurationManager.AppSettings["postgresql_database"];
string CONNECTION_STRING = buildpostgresqlconnectionstringfromobject(_connectionstringdto);
return(CONNECTION_STRING);
}
