/// <summary> /// Adds a new environment into the system /// </summary> /// <param name="environment"></param> public void Add(SqlEnvironment environment) { if (!EnvironmentList.Contains(environment)) { string n = environment.EnvironmentName; foreach(SqlEnvironment e in EnvironmentList) { if(e.EnvironmentName == n) { throw new DataException("Environment " + n + " already exists"); } } EnvironmentList.Add(environment); if(environment.IsCurrent) { SetCurrentEnvironment(environment.EnvironmentName); SQLDMGlobal.Initialise(); } } }
private static void GetEnvironments() { if (_EnvironmentsCollected) return; _EnvironmentsCollected = true; foreach (Configuration.SQLDataManagerElement envElement in Configuration.SQLDataManager.GetEnvironments()) { SqlEnvironment env = new SqlEnvironment(envElement.Name); ConnectionManager cm = ConnectionManager.GetConnectionManager(); env.IsCurrent = envElement.IsCurrent; env.InitialCatalog = envElement.InitialCatalogue; env.IntegratedSecurity = envElement.IntegratedSecurity; env.ConnectionTimeout = envElement.ConnectionTimeout; env.DataSource = envElement.DataSource; env.Schema = envElement.Schema; env.UserID = envElement.UserID; env.Password = envElement.Password; cm.Add(env); } }