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