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); }