public void GetSettings_ReadsConfiguration()
{
// arrange
var helper = new DatabaseConnectionsHelper();
// act
var result = helper.GetConnections();
// assert
Assert.That(result.Count, Is.EqualTo(5));
}
public void GetSettings_SettingsHaveCorrectValues()
{
// arrange
var helper = new DatabaseConnectionsHelper();
// act
var result = helper.GetConnections();
// assert
var setting = result[0];
Assert.That(setting.Type, Is.EqualTo("SqlServer"));
Assert.That(setting.Name, Is.EqualTo("Development"));
Assert.That(setting.Server, Is.EqualTo(@".\sqlexpress"));
Assert.That(setting.Database, Is.EqualTo("dev_db"));
Assert.That(setting.Schema, Is.Empty);
Assert.That(setting.Username, Is.EqualTo("user"));
Assert.That(setting.Password, Is.EqualTo("password"));
setting = result[1];
Assert.That(setting.Type, Is.EqualTo("SqlServer"));
Assert.That(setting.Name, Is.EqualTo("Production"));
Assert.That(setting.Server, Is.EqualTo("SomeServer"));
Assert.That(setting.Database, Is.EqualTo("prod_db"));
Assert.That(setting.Schema, Is.EqualTo("custom"));
Assert.That(setting.Username, Is.EqualTo("user"));
Assert.That(setting.Password, Is.EqualTo("password"));
setting = result[3];
Assert.That(setting.Type, Is.EqualTo("SqlServerCompact"));
Assert.That(setting.Name, Is.EqualTo("SomeCompactDb"));
Assert.That(setting.File, Is.EqualTo(@"c:\somefile.sdf"));
setting = result[4];
Assert.That(setting.Type, Is.EqualTo("SqlServer"));
Assert.That(setting.Name, Is.EqualTo("SelectApplication"));
Assert.That(setting.Database, Is.EqualTo("elmah"));
Assert.That(setting.Application, Is.EqualTo("some-website"));
}
