public void TestCleanUp() { //Delete Bet TransactionOptions to = new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted }; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, to)) { using (SqlConnection connection = GetSqlConnection()) { connection.Open(); using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "DELETE FROM TeamsOnBetsOnMatch WHERE TeamId=@id"; command.Parameters.AddWithValue("id", TestTeam1.Id); command.ExecuteNonQuery(); command.Parameters.Clear(); command.CommandText = "DELETE FROM BetsOnmatch WHERE BetId=@id"; command.Parameters.AddWithValue("id", TestBet.Id); command.ExecuteNonQuery(); command.Parameters.Clear(); command.CommandText = "DELETE FROM Bet WHERE Id=@id"; command.Parameters.AddWithValue("id", TestBet.Id); command.ExecuteNonQuery(); } connection.Close(); } scope.Complete(); } //Delete TestUser UserController.DeleteUser(TestUser); //Delete TestPlayers foreach (Player p in TestTeam1.Players) { PlayerController.DeletePlayer(p); } foreach (Player p in TestTeam2.Players) { PlayerController.DeletePlayer(p); } //Delete TestMatch MatchController.DeleteMatch(TestMatch); //Delete TestEvent EventController.DeleteEvent(TestEvent); //Delete TestTeam TeamController.DeleteTeam(TestTeam1); TeamController.DeleteTeam(TestTeam2); //Delete TestMap MatchController.DeleteMap(TestMap); }