public void Delete_DeletesRowFromUmbracoNode()
        {
            EnsureTestDocumentTypes();
            var originalCount = database.ExecuteScalar <int>("SELECT COUNT(*) FROM umbracoNode");

            try
            {
                var node = new CMSNode(testContentType2.Id);
                database.Execute("DELETE cmsContentType WHERE nodeId = @NodeId", new { NodeId = node.Id });
                node.delete();
                Assert.AreEqual(0, database.ExecuteScalar <int>("SELECT COUNT(*) FROM umbracoNode WHERE id = @id", new { id = node.Id }));;
                var newCount = database.ExecuteScalar <int>("SELECT COUNT(*) FROM umbracoNode");
                Assert.AreEqual(originalCount - 1, newCount);
            }
            finally
            {
                ResetTestDocumentTypes();
            }
        }