Try our conversational search powered by Generative AI!

Patrick Ibert
Aug 18, 2011
  5067
(4 votes)

Implement a comment system using EPiServers datastore by using Paul Smith's DynamicDataStoreSession class

Hi!

First I would want to start this post by thanking Paul Smith for taking the time to point out the mistakes I had done in the last post I did about this, I learned a lot how to use the datastore in a correct way from his help! Thanks Paul!

This post is about how we can use Paul Smith's DynamicDataStoreSession class with very little code to implement a comment system for our EPi pages using the EPiServer datastore.

The idea is that I will create an Usercontrol that I can place on a page where I want people to be able to comment the content.


I start off with creating my entity class:


     public class Comment
    {
        public Identity Id { get; set; }
        [EPiServerDataIndex]
        public Guid PageGuid { get; set; } 
        public string UserName { get; set; }
        public string Location { get; set; }
        public string UserComment { get; set; }
        public DateTime Date { get; set; }
    }


Note that my PageGuid property has the attribute [EPiServerDataIndex], it will tell the DDS to map the property to an indexed database column, which will speed up retrieving the data.

I then make a factory class were I will add my datastore methods:


     public static IEnumerable<Comment> GetComments(Guid pageGuid)
        {
            var session = new DynamicDataStoreSession<Comment>();
            return session.Find().Where(p => p.PageGuid).Equals(pageGuid).Go().OrderByDescending(p => p.Date);
        }

        public static void SubmitComment(string comment, Guid pageGuid)
        {
            var store = new DynamicDataStoreSession<Comment>();
            var newComment = new Comment
            {
                Id = Identity.NewIdentity(Guid.NewGuid()),
                UserName = Membership.GetUser().UserName,
                Location = "Stockholm, Sweden",
                UserComment = comment,
                Date = DateTime.Now,
                PageGuid = pageGuid
            };
            store.Save(newComment); 
           

        }


My usercontrol looks like this:

<asp:Repeater ID="repComments" runat="server">
                <ItemTemplate>
                   <tr>
                   <td><%# DataBinder.Eval(Container.DataItem, "UserName")%> (<%# DataBinder.Eval(Container.DataItem, "Location")%>) </td>
                   <td><br /><%# DataBinder.Eval(Container.DataItem, "UserComment")%></td><br /><br />
                 </tr> 
                </ItemTemplate>
                </asp:Repeater>


and in the code behind:

  protected void Page_Load(object sender, EventArgs e)
        {
           repComments.DataSource = ArticleComment.GetComments(CurrentPage.PageGuid);
           repComments.DataBind();
       }

        protected void btnComment_Click(object sender, EventArgs e)
        {
            if (tbComment.Text == "")
                return;
            ArticleComment.SubmitComment(tbComment.Text, CurrentPage.PageGuid);
            repComments.DataSource = ArticleComment.GetComments(CurrentPage.PageGuid);
            repComments.DataBind();
            tbComment.Text = "";
        }


I hope you had fun and found this post useful :)

Aug 18, 2011

Comments

Aug 18, 2011 03:54 PM

Hi Patrick, nice blog post. I learned some stuff! :)

But doesn't the code below mean that the [EPIServerDataIndex] is an attribute to UserName, not PageGuid?

public Guid PageGuid { get; set; }
[EPiServerDataIndex]
public string UserName { get; set; }

Maybe it's my c# skills that isn't up to par when it comes to attributes.

smithsson68@gmail.com
smithsson68@gmail.com Aug 18, 2011 04:12 PM

Hi Patrick!

Your code is looking great now except for the small mistake that Toni has pointed out. You need to declare the attribute on top on the member. When you change this you will find that your app crashes as the class definition no longer matches the DDS store definition. You get around this easily by adding the following attribute to your Comment class:

[EPiServerDataStore(AutomaticallyRemapStore=true)]

With this added your store will automatically align to the class the first time the store is accessed.

Thanks for sharing!

/Paul

Patrick Ibert
Patrick Ibert Aug 18, 2011 05:03 PM

Hi!
Oh Yea I thought about that before if it wasent wrong, I guess I missunderstood that part some.
Thanks for pointing it out, updated the post with it.

/Patrick

Please login to comment.
Latest blogs
Optimizely Web... 6 Game Changing Features in 2024

If you are interested in learning about what's new within Optimizely Web, you are in the right place. Carry on reading to learn about the 6 greates...

Jon Jones | Mar 3, 2024 | Syndicated blog

Headless forms reloaded (beta)

Forms is used on the vast majority of CMS installations. But using Forms in a headless setup is a bit of pain since the rendering pipeline is based...

MartinOttosen | Mar 1, 2024

Uploading blobs to Optimizely DXP via PowerShell

We had a client moving from an On-Prem v11 Optimizely instance to DXP v12 and we had a lot of blobs (over 40 GB) needing uploading to DXP as a part...

Nick Hamlin | Mar 1, 2024 | Syndicated blog

DbLocalizationProvider v8.0 Released

I’m pleased to announce that Localization Provider v8.0 is finally out.

valdis | Feb 28, 2024 | Syndicated blog