Ejemplos de CampgroundSqlDAO.FindCampgroundId en C# (CSharp)

Ejemplo n.º 1

Archivo: CampgroundDAOTests.cs Proyecto: jalen441/National_Park_Registration_Service

        public void FindCampgroundIdTest()
        {
            // Arrange
            int campgroundId = 0;

            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                SqlCommand command = new SqlCommand(
                    @"SELECT campground_id
                      FROM site
                      WHERE site_number = 5",
                    connection);

                connection.Open();

                campgroundId = Convert.ToInt32(command.ExecuteScalar());
            }

            //Act and Assert
            Assert.AreEqual(campgroundId, dao.FindCampgroundId("The Back Yard"));
        }