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); }