RavenDB：排序、索引和投影

发布于 2025-01-08 02:07:15 字数 778 浏览 0 评论 0原文

假设我有一个如下所示的模型：

public class Blog
{
    public string BlogId { get; set; }
    public string Name { get; set; }
    public DateTime Created { get; set; }
}

public class Post
{
    public string PostId { get; set; }
    public string BlogId { get; set; }
    public string Text { get; set; }
}

我有很多博客，每个博客都有很多帖子。现在我想要一个像这样的“博客摘要视图”：

public class BlogSummaryView
{
    public string Id { get; set; }
    public string Name { get; set; }
    public DateTime Created { get; set; }
    public int PostCount { get; set; }
}

如果我希望能够对创建日期和帖子数量<进行排序，我应该如何获取此列表/em>?

我可以添加一个映射/归约索引来获取每个博客的帖子数量并对其进行排序，但我无法使用此索引对博客创建日期进行排序。

添加地图索引使我可以按创建日期排序。不过，这个索引不允许我对帖子数量进行排序，除非我遗漏了一些东西。

原文

Let's say I have a model that looks like this:

public class Blog
{
    public string BlogId { get; set; }
    public string Name { get; set; }
    public DateTime Created { get; set; }
}

public class Post
{
    public string PostId { get; set; }
    public string BlogId { get; set; }
    public string Text { get; set; }
}

I have many blogs, each with many posts. Now I want a "blog summary view" like this:

public class BlogSummaryView
{
    public string Id { get; set; }
    public string Name { get; set; }
    public DateTime Created { get; set; }
    public int PostCount { get; set; }
}

How should I go about to get this list if I want to be able to sort both on the creation date and the number of posts?

I can add a map/reduce index to get the number of posts per blog and sort on it, but I would not be able to sort on blog creation date with this index.

Adding a map index gives me the possibility to sort by creation date. This index would not allow me to sort on number of posts though, unless there is something I'm missing.

分享到QQ

分享到微博