public void ListSpacesNotReservedForAllVenuesTest() { ReservationSqlDAO reservationDAO = new ReservationSqlDAO(connectionString); List <Reservation> spaceList = reservationDAO.ListSpacesNotReservedForAllVenues(Convert.ToDateTime("06/25/2020"), Convert.ToDateTime("06/30/2020")); bool result = false; foreach (Reservation res in spaceList) { if (res.Name == "The Royal Room") { result = true; } } Assert.IsTrue(result); }