public override BlogItem GetBlog(int id)
        {
            // create the post provider object
            Blog_Posts posts = new Blog_Posts();
            posts.ID = id;

            // get the post with the id
            DataTable table = posts.SelectOne();

            // check to see if a row was returned
            if (table.Rows.Count > 0)
                return this.BuildBlog(table.Rows[0]);

            // nothing was found return null
            return null;
        }
        public override void AddBlog(BlogItem item)
        {
            // create the post from the item
            Blog_Posts post = new Blog_Posts();
            post.Title = item.Title;
            post.Body = item.Body;
            post.Published = item.Published;
            post.AllowComments = item.AllowComments;
            post.Syndicate = item.Syndicate;
            post.User_ID = item.PosterID;
            post.TitleUrl = (item.TitleUrl != null) ? item.TitleUrl.ToString() : null;
            post.Source = item.Source;
            post.SourceUrl = (item.SourceUrl != null) ? item.SourceUrl.ToString() : null;
            post.Created = item.Created;
            post.Issued = item.Issued;
            post.Modified = item.Modified;

            // insert the post into the database
            post.Insert();
        }
        public override void RemoveBlog(int id)
        {
            Blog_Posts post = new Blog_Posts();
            post.ID = id;

            post.Delete();
        }