static string buildmssqlconnectionstringfromobject(mssqlconnectionstringdto _connectionstringdto)
{
string CONNECTION_STRING = @"Data Source=" + _connectionstringdto.datasource + ";" +
"Database=" + _connectionstringdto.database + ";" +
"User Id=" + _connectionstringdto.userid + ";" +
"Password=" + _connectionstringdto.password;
return(CONNECTION_STRING);
}
public static string getdefaultmssqlconnectionstring()
{
mssqlconnectionstringdto _connectionstringdto = new mssqlconnectionstringdto();
_connectionstringdto.datasource = System.Configuration.ConfigurationManager.AppSettings["mssql_datasource"];
_connectionstringdto.database = System.Configuration.ConfigurationManager.AppSettings["mssql_database"];
_connectionstringdto.userid = System.Configuration.ConfigurationManager.AppSettings["mssql_userid"];
_connectionstringdto.password = System.Configuration.ConfigurationManager.AppSettings["mssql_password"];
_connectionstringdto.port = System.Configuration.ConfigurationManager.AppSettings["mssql_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["mssql_database"];
string CONNECTION_STRING = buildmssqlconnectionstringfromobject(_connectionstringdto);
return(CONNECTION_STRING);
}
