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>"); }
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)); }
/// <summary>The load up connections.</summary> private void LoadUpConnections() { DbConnectionDefinitionList definitionList = _settings.GetConnectionDefinitions(); if (_initialized) // if initialized, just sync the lists { // add missing foreach (var connDef in definitionList.Definitions) { if (!toolStripComboBoxConnection.Items.Contains(connDef)) { toolStripComboBoxConnection.Items.Add(connDef); } } // remove if missing var defList = new List <DbConnectionDefinition>(definitionList.Definitions); for (int i = toolStripComboBoxConnection.Items.Count - 1; i >= 0; i--) { var connDef = (DbConnectionDefinition)toolStripComboBoxConnection.Items[i]; if (!defList.Contains(connDef)) { toolStripComboBoxConnection.Items.RemoveAt(i); } } } else { // first populate toolStripComboBoxConnection.Items.Clear(); foreach (var connDef in definitionList.Definitions) { toolStripComboBoxConnection.Items.Add(connDef); } } // Bug fix - don't automatically refresh as it can try to reconnect to a connection you don't have etc. //foreach (var connDef in definitionList.Definitions) //{ // if (connDef.Name == Settings.Default.NammedConnection) // { // toolStripComboBoxConnection.SelectedItem = connDef; // _settings.ConnectionDefinition = connDef; // SetWindowTitle(connDef.Name); // } //} }
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_Deserialize_a_DbConnectionDefinitionList_from_XML_string() { string xml = @"<DbConnectionDefinitionList xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema""> <DefaultName>default</DefaultName> <Definitions> <DbConnectionDefinition> <Name>nm1</Name> <ConnectionString>cs1</ConnectionString> </DbConnectionDefinition> <DbConnectionDefinition> <Name>nm2</Name> <ConnectionString>cs2</ConnectionString> </DbConnectionDefinition> </Definitions> </DbConnectionDefinitionList>"; DbConnectionDefinitionList definitionList = DbConnectionDefinitionList.FromXml(xml); Assert.That(definitionList.DefaultName, Is.EqualTo("default")); Assert.That(definitionList.Definitions[0].Name, Is.EqualTo("nm1")); Assert.That(definitionList.Definitions[0].ConnectionString, Is.EqualTo("cs1")); Assert.That(definitionList.Definitions[1].Name, Is.EqualTo("nm2")); }
/// <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 load connection definitions.</summary> /// <returns></returns> private static DbConnectionDefinitionList LoadConnectionDefinitions() { return(DbConnectionDefinitionList.FromXml(Utility.LoadConnections())); }
/// <summary>The save connection definitions.</summary> /// <param name="data">The data.</param> private void SaveConnectionDefinitions(DbConnectionDefinitionList data) { _settings.SetConnectionDefinitions(data); Utility.SaveConnections(data); _dirty = false; }
/// <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(); _loaded = true; }