/// <summary> /// Saves the <paramref name = "definitionList" /> to the connection string file. /// </summary> /// <param name = "definitionList">The contents of the file.</param> /// <seealso cref = "GetConnectionStringFilename" /> public static void SaveConnections(DbConnectionDefinitionList definitionList) { string filename = GetConnectionStringFilename(); string newXml = definitionList.ToXml(); File.WriteAllText(filename, newXml); }
/// <summary> /// Loads the db connection definitions from an XML file. /// </summary> /// <returns>A <see cref = "DbConnectionDefinitionList" /> instance or null if the file does not exist.</returns> public static DbConnectionDefinitionList LoadDbConnectionDefinitions() { string filename = GetConnectionStringFilename(); DbConnectionDefinitionList definitionList = null; if (File.Exists(filename)) { definitionList = DbConnectionDefinitionList.FromXml(File.ReadAllText(filename)); } return(definitionList); }
public void Can_add_DbConnectionDefinition_object() { DbConnectionDefinitionList definitionList = new DbConnectionDefinitionList(); definitionList.DefaultName = "def"; definitionList.Definitions = new[] { new DbConnectionDefinition {ConnectionString = "cs1", Name = "nm1", ProviderName = "p1"}, new DbConnectionDefinition {ConnectionString = "cs2", Name = "nm2", ProviderName = "p2"} }; Assert.That(definitionList.Definitions.Length, Is.EqualTo(2)); definitionList.AddDefinition(new DbConnectionDefinition {ConnectionString = "cs3", Name = "nm3", ProviderName = "p3"}); Assert.That(definitionList.Definitions.Length, Is.EqualTo(3)); }
public void Can_remove_a_DbConnectionDefinition_object() { DbConnectionDefinitionList definitionList = new DbConnectionDefinitionList(); definitionList.DefaultName = "def"; var conn1 = new DbConnectionDefinition {ConnectionString = "cs1", Name = "nm1", ProviderName = "p1"}; var conn2 = new DbConnectionDefinition {ConnectionString = "cs2", Name = "nm2", ProviderName = "p2"}; var conn3unused = new DbConnectionDefinition {ConnectionString = "cs3", Name = "nm3", ProviderName = "p3"}; definitionList.Definitions = new[] {conn1, conn2}; Assert.That(definitionList.Definitions.Length, Is.EqualTo(2)); bool remove1=definitionList.RemoveDefinition(conn2); Assert.That(remove1, Is.EqualTo(true)); Assert.That(definitionList.Definitions.Length, Is.EqualTo(1)); Assert.That(definitionList.Definitions[0].Name, Is.EqualTo("nm1")); bool remove2 = definitionList.RemoveDefinition(conn3unused); Assert.That(remove2, Is.EqualTo(false)); Assert.That(definitionList.Definitions.Length, Is.EqualTo(1)); }
public void Can_serialize_a_DbConnectionDefinitionList() { DbConnectionDefinitionList definitionList = new DbConnectionDefinitionList(); definitionList.DefaultName = "def"; definitionList.Definitions = new[] { new DbConnectionDefinition {ConnectionString = "cs1", Name = "nm1", ProviderName = "p1"}, new DbConnectionDefinition {ConnectionString = "cs2", Name = "nm2", ProviderName = "p2"} }; string xml = definitionList.ToXml(); //Console.WriteLine(xml); xml.Should().Contain("<DefaultName>def</DefaultName>"); xml.Should().Contain("<Name>nm1</Name>"); xml.Should().Contain("<ConnectionString>cs1</ConnectionString>"); xml.Should().Contain("<ProviderName>p1</ProviderName>"); xml.Should().Contain("<Name>nm2</Name>"); xml.Should().Contain("<ConnectionString>cs2</ConnectionString>"); xml.Should().Contain("<ProviderName>p2</ProviderName>"); }
/// <summary>Initializes a new instance of the <see cref="ApplicationSettings"/> class.</summary> public ApplicationSettings() { _definitionList = new DbConnectionDefinitionList(); }
/// <summary>The set connection definitions.</summary> /// <param name="definitionList">The definition list.</param> public void SetConnectionDefinitions(DbConnectionDefinitionList definitionList) { _definitionList = definitionList; OnPastConnectionStringsChanged(EventArgs.Empty); }
/// <summary>The db connections form_ shown.</summary> /// <param name="sender">The sender.</param> /// <param name="e">The e.</param> private void DbConnectionsForm_Shown(object sender, EventArgs e) { _definitionList = LoadConnectionDefinitions(); UpdateListView(); }
/// <summary>The save connection definitions.</summary> /// <param name="data">The data.</param> private void SaveConnectionDefinitions(DbConnectionDefinitionList data) { _settings.SetConnectionDefinitions(data); Utility.SaveConnections(data); }