public void Delete_WithScenarioDataInDatabase_ExpectInvalidOperationException(
            int id)
        {
            // Arrange
            var classUnderTest = new IndividualDal(ConnectionString);

            var entity =
                new IndividualEntity
                {
                    Id = id,
                };

            // Act
            classUnderTest.Delete(entity);

            // Assert
            Assert.Fail("Expected an exception");
        }
        public void Delete_WithScenarioDataInDatabase_ExpectEntityIsRemoved(
            int id)
        {
            // Arrange
            var classUnderTest = new IndividualDal(ConnectionString);

            var entity = classUnderTest.Retrieve(id);
            Assert.NotNull(entity);

            // Act
            classUnderTest.Delete(entity);

            // Assert
            var result = classUnderTest.Retrieve(id);
            Assert.IsNull(result);
        }