static string buildmysqlconnectionstringfromobject(mysqlconnectionstringdto _connectionstringdto)
{
string CONNECTION_STRING = @"host=" + _connectionstringdto.datasource + ";" +
"database=" + _connectionstringdto.database + ";" +
"port=" + _connectionstringdto.port + ";" +
"user="******";" +
"password=" + _connectionstringdto.password;
return(CONNECTION_STRING);
}
public static string getdefaultmysqlconnectionstring()
{
mysqlconnectionstringdto _connectionstringdto = new mysqlconnectionstringdto();
_connectionstringdto.datasource = System.Configuration.ConfigurationManager.AppSettings["mysql_datasource"];
_connectionstringdto.database = System.Configuration.ConfigurationManager.AppSettings["mysql_database"];
_connectionstringdto.userid = System.Configuration.ConfigurationManager.AppSettings["mysql_userid"];
_connectionstringdto.password = System.Configuration.ConfigurationManager.AppSettings["mysql_password"];
_connectionstringdto.port = System.Configuration.ConfigurationManager.AppSettings["mysql_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["mysql_database"];
string CONNECTION_STRING = buildmysqlconnectionstringfromobject(_connectionstringdto);
return(CONNECTION_STRING);
}
