public Database SetConnectionString(string connectionStringOrSettingName, ConnectionStringMode mode = ConnectionStringMode.AppSettings)
{
switch (mode)
{
case ConnectionStringMode.Raw:
ConnectionString = connectionStringOrSettingName;
break;
case ConnectionStringMode.AppSettings:
ConnectionString = GetConnectionStringByConfig(connectionStringOrSettingName);
break;
}
return(this);
}
private void ToggleConnectionStringBuilder(bool enable)
{
rdConnString.Checked = !enable;
rdConnStringWizard.Checked = enable;
_connectionMode = ConnectionStringMode.FullString;
txtServerName.Enabled =
txtCatalogue.Enabled =
txtPassword.Enabled =
txtUserName.Enabled =
ckActiveResults.Enabled =
ckIntegratedSecurity.Enabled =
ckPersistSecurityInfo.Enabled = enable;
txtConnectionString.Enabled = !enable;
}
private static string GetConnection(ConnectionStringMode connectionMode)
{
string _connection = string.Empty;
switch (connectionMode)
{
case ConnectionStringMode.OdbcConnectionString:
_connection = "Driver={Amazon Redshift (x64)}; Server=hadv111.c8qg9vzfzs00.us-east-1.redshift.amazonaws.com; Database=padb; UID=ha; PWD=Hudson234; Port=5439; UseDeclareFetch=1; Fetch=10000";
//_connection = "Driver={Amazon Redshift (x64)}; Server=hadv111.c8qg9vzfzs00.us-east-1.redshift.amazonaws.com; Database=padb; UID=ha_readonly; PWD=y863ENI74V; Port=5439; UseDeclareFetch=1; Fetch=10000";
break;
case ConnectionStringMode.SqlServerConnectionString:
//_connection = @"Data Source=DAL0IWRMBSQLP03;Initial Catalog=RMBS;User Id=RMBS_USER;Password=rmbs;MultipleActiveResultSets=True";
_connection = @"Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=ConstructionDB;Integrated Security=SSPI;";
//_connection = ConfigurationManager.ConnectionStrings["SqlServerConnectionString"].ToString();
break;
}
return(_connection);
}
