Esempio n. 1
0
        public void TestToSeeIfRowIsDeleted()
        {
            // Arrange
            int    count = 1;
            var    sut   = new TerritoryTable();
            String territoryIndexString = "This is territoryIndex1";
            String sqlString            = "DELETE FROM Territories WHERE territoryIndex='" + territoryIndexString + "';";

            // Act
            TT.DeleteRowFromTable(territoryIndexString);
            SqlCommand    command  = new SqlCommand(sqlString, s_connection);
            SqlDataReader myReader = command.ExecuteReader();

            while (myReader.Read())
            {
                count++;
            }

            // Assert
            Assert.AreEqual(1, count);
        }