public static void Save() { var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); SetValue(config, "ServerName", ServerName); SetValue(config, "DatabaseName", DatabaseName); SetValue(config, "UserName", UserName); SetValue(config, "ConnectionTimeout", ConnectionTimeout.ToString(CultureInfo.InvariantCulture)); SetValue(config, "CommandTimeout", CommandTimeout.ToString(CultureInfo.InvariantCulture)); var value = (Password.Length > 0) ? SymCryptoHelper.TripleDESEncrypt(Password, Salt, Key, IV) : string.Empty; SetValue(config, "Password", value); SetValue(config, "LoginUserName", LoginUserName); SetValue(config, "LoginPassword", LoginPassword); SetValue(config, "AutoNewRow", AutoNewRow); SetValue(config, "OfflineMode", OfflineMode); SetValue(config, "OfflineServerName", OfflineServerName); SetValue(config, "OfflineDatabaseName", OfflineDatabaseName); SetValue(config, "OfflineUserName", OfflineUserName); SetValue(config, "OfflineConnectionTimeout", OfflineConnectionTimeout.ToString(CultureInfo.InvariantCulture)); SetValue(config, "OfflineCommandTimeout", OfflineCommandTimeout.ToString(CultureInfo.InvariantCulture)); value = (OfflinePassword.Length > 0) ? SymCryptoHelper.TripleDESEncrypt(OfflinePassword, Salt, Key, IV) : string.Empty; SetValue(config, "OfflinePassword", value); SetValue(config, "SynchronizationProvider", GetStringValue("SynchronizationProvider")); SetValue(config, "WSSynchronizationUrl", GetStringValue("WSSynchronizationUrl")); SetValue(config, "WSUserName", GetStringValue("WSUserName")); SetValue(config, "WSPassword", GetStringValue("WSPassword")); SetValue(config, "WSDomain", GetStringValue("WSDomain")); SetValue(config, "SkinName", SkinName); SetValue(config, "AllowFormSkins", AllowFormSkins); SetValue(config, "UseHedgehog", UseHedgehog); SetValue(config, "HedgehogFile", HedgehogFile); config.Save(); BuilderConnectionStrings(); }
/// <summary> /// Constructs a connection string from the sql settings. /// </summary> /// <returns>Connection string.</returns> public String ToConnectionString() { StringBuilder connectionString = new StringBuilder(); connectionString.Append(m_ConnectionString); // Strip the last semicolon. if (m_ConnectionString.EndsWith(";", StringComparison.OrdinalIgnoreCase)) { connectionString.Remove(m_ConnectionString.Length - 1, 1); } if (!String.IsNullOrEmpty(InitialCatalog)) { connectionString.Append(";Initial Catalog="); connectionString.Append(InitialCatalog); } if (MinPoolSize != -1) { connectionString.Append(";Min Pool Size="); connectionString.Append(MinPoolSize.ToString(CultureInfo.InvariantCulture)); } if (MaxPoolSize != -1) { connectionString.Append(";Max Pool Size="); connectionString.Append(MaxPoolSize.ToString(CultureInfo.InvariantCulture)); } if (ConnectionTimeout != -1) { connectionString.Append(";Connection Timeout="); connectionString.Append(ConnectionTimeout.ToString(CultureInfo.InvariantCulture)); } return(connectionString.ToString()); }