/// <summary> /// Sets the specified environment to be the current one in use /// </summary> /// <param name="environmentName">The environment to be assigned as current</param> public void SetCurrentEnvironment(string environmentName) { SqlEnvironment e = GetEnvironment(environmentName); foreach (SqlEnvironment env in EnvironmentList) { env.IsCurrent = (env == e); } }
/// <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); } }