public void CorrectlyGeneratesConnectionStringWithDatabaseAndUserSecurityAndDatabaseExcluded()
{
IConnectionStringGenerator generator = new ConnectionStringGenerator();
ConnectionSettings settings = new ConnectionSettings("server", "db", false, "usr", "pwd");
string connString = generator.GetConnectionString(settings, false);
Assert.AreEqual("Data Source=server;User ID=usr;Password=pwd;", connString);
}
public void CorrectlyGeneratesConnectionStringWithDatabaseAndIntegratedSecurityAndDatabaseExcluded()
{
IConnectionStringGenerator generator = new ConnectionStringGenerator();
ConnectionSettings settings = new ConnectionSettings("server", "db", true, string.Empty, string.Empty);
string connString = generator.GetConnectionString(settings, false);
Assert.AreEqual("Data Source=server;Integrated Security=True;", connString);
}
private void QueryUsdAppliedDatabaseScriptTable(ConnectionSettings settings, Action<SqlDataReader> action)
{
string connectionString = new ConnectionStringGenerator().GetConnectionString(settings, true);
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
using (var command = new SqlCommand())
{
command.Connection = connection;
command.CommandText =
"SELECT [ScriptFile],[DateApplied],[Version],[hash] FROM [dbo].[usd_AppliedDatabaseScript]";
using (SqlDataReader reader = command.ExecuteReader())
{
action(reader);
}
}
}
}