ontent By Query web part with social capabilities

SocialCBQ.cs

    /// <summary>
    /// Adding social comments to the results of Content Query web part 
    /// </summary>
    [ToolboxItem(false)] 
    public class SocialCBQ : ContentByQueryWebPart
    {
        protected override void OnInit(EventArgs e)
        {
            base.OnInit(e);
            this.ProcessDataDelegate = ProcessSocialData;
        }

        private DataTable ProcessSocialData(DataTable data)
        {
            var context = SPServiceContext.GetContext(SPContext.Current.Site);
            scm = new SocialCommentManager(context);
            data.Columns.Add("PageUrl", typeof(string));
            data.Columns.Add("PageComments", typeof(int));
            foreach (DataRow row in data.Rows)
            {
                var fileRefVal = new SPFieldLookupValue((string)row[SPBuiltInFieldId.FileRef.ToString("B")]);
                string pageUrl = SPContext.Current.Site.MakeFullUrl("/" + fileRefVal.LookupValue);
                var pageComments = scm.GetCount(new Uri(pageUrl));
                row["PageUrl"] = pageUrl;
                row["PageComments"] = pageComments;
            }
            return data;
        }


        private SocialCommentManager scm;
    }