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