public static void SaveConnection(ConnectionDetail connectionDetail) { var connectionElement = new ConnectionElement(); connectionElement.FromConnectionDetail(connectionDetail); var configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); var connectionsSection = (ConnectionSection) configuration.Sections["DBViewConnections"]; if (connectionsSection != null) connectionsSection.Connections.Add(connectionElement); else { connectionsSection = new ConnectionSection(); connectionsSection.Connections.Add(connectionElement); configuration.Sections.Add("DBViewConnections", connectionsSection); } connectionsSection.SectionInformation.ForceSave = true; configuration.Save(ConfigurationSaveMode.Full); }
public static void DeleteConnection(ConnectionDetail connectionDetail) { var connectionElement = new ConnectionElement(); connectionElement.FromConnectionDetail(connectionDetail); var configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); var connectionsSection = (ConnectionSection) configuration.Sections["DBViewConnections"]; if (connectionsSection == null) return; connectionsSection.Connections.Remove(connectionElement); connectionsSection.SectionInformation.ForceSave = true; configuration.Save(ConfigurationSaveMode.Full); }