public void GetReservationByIDTest()
{
// Arrange
IReservationDAO dao = new ReservationSqlDAO(connection);
// Act
Reservation r = dao.GetReservationByID(4);
// Assert
Assert.AreEqual("Bauer Family Reservation", r.Name);
Assert.IsNull(dao.GetReservationByID(50));
}