Mar 24, 2011 at 7:45 PM
Edited Mar 24, 2011 at 7:45 PM
I want to make a module that show the most commented blogposts of a certain timespan but I cann't figure how to join the information.
The comments are accessible by
//linq query on the following
And I would like to join the CommentPartRecord's table with a record of a blog, but when I looked into the Orchard.Blogs module I couldn't find a blog record or anything else that could give me an System.Linq.IQueryable.
The necessary information about the blogpost is the text (for a preview) and the PublishedUtc
Is there a way to do something like:
join p in WANTED on c.CommentedOn equals popularPostPart.Id
group c by c.CommentedOn into g
PostId = g.Key,
CommentCount = g.Count(),
I have unsuccessfully tried things like:
Any help is welcome :)