Skip to content

Instantly share code, notes, and snippets.

@jbogard
Created October 8, 2012 13:21
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jbogard/3852502 to your computer and use it in GitHub Desktop.
Save jbogard/3852502 to your computer and use it in GitHub Desktop.
public class ListPostsQuery
{
private readonly IDocumentSession session;
public ListPostsQuery(IDocumentSession session)
{
this.session = session;
}
public List<Post> Execute(int currentPage, int defaultPage, int pageSize, out RavenQueryStatistics stats)
{
return session.Query<Post>()
.Include(x => x.AuthorId)
.Statistics(out stats)
.WhereIsPublicPost()
.OrderByDescending(post => post.PublishAt)
.Paging(currentPage, defaultPage, pageSize)
.ToList();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment