public void GetAllOpenCampgroundsTest()
        {
            // Arrange
            IList <Campground> cgrounds;

            ICampgroundDAO dao = new CampgroundSqlDAO(connection);

            // Act
            cgrounds = dao.GetAllOpenCampgrounds(3);

            // Assert
            Assert.AreEqual(4, cgrounds.Count);
        }