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;
}
