public void CanScriptOutAlevinDatabase() { try { var testSubject = new DatabaseBackupViaSqlFileCreator(DatabaseServer, "AlevinDB"); // Act // --- string sqlBackup = testSubject.CreateSqlBackup(); // Assert // ------ Approvals.Verify(sqlBackup); } finally { } }
public void CanScriptOutDatabase() { // Arrange // ------- using (var initialConn = new SqlConnection(string.Format("Server={0};Database={1};Trusted_Connection=True;pooling=false", DatabaseServer, DefaultStartDatabase))) { initialConn.Open(); CleanupDatabase(initialConn); SetupTestDatabase(initialConn); initialConn.Close(); } try { var testSubject = new DatabaseBackupViaSqlFileCreator(DatabaseServer, _testDatabaseName); // Act // --- string sqlBackup = testSubject.CreateSqlBackup(); // Assert // ------ Approvals.Verify(sqlBackup); } finally { using (var secondConn = new SqlConnection(string.Format("Server={0};Database={1};Trusted_Connection=True;pooling=false", DatabaseServer, DefaultStartDatabase))) { secondConn.Open(); // Clean up // --------- CleanupDatabase(secondConn); secondConn.Close(); } } }