如何将 RavenDb 查询索引结果包含到文档中

发布于 2024-10-28 20:56:57 字数 388 浏览 2 评论 0原文

以下两个查询均按预期工作。我无法弄清楚如何使用“Include()”方法一次从数据库返回两者。

var result = _documentsSession
    .Advanced
    .LuceneQuery<MessageStatisticResult, MessageSummaryByUserIndex>()
    .Where("Email:" + command.UserName);

var user = _documentSession
    .Load<IUser>("users/" + command.UserName);

一旦我添加“Include()”方法，Query() 和 Advance() 就不再相关。有办法做到这一点吗？

原文

Both of the following queries work as expected. I'm having trouble figuring out how to return both from the database in one pull using the "Include()" method.

var result = _documentsSession
    .Advanced
    .LuceneQuery<MessageStatisticResult, MessageSummaryByUserIndex>()
    .Where("Email:" + command.UserName);

var user = _documentSession
    .Load<IUser>("users/" + command.UserName);

A soon as I add the "Include()" method both the Query() and Advance() are no longer relevant. Is there a way to do this?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

紫﹏色ふ单纯 2024-11-04 20:56:57

这也会产生结果，但不会在一次访问数据库中同时获得这两个结果：

var result = _documentsSession
    .Query<MessageStatisticResult, MessageSummaryByUserIndex>()
    .Customize(x => x.Include("users/" + command.UserName))
    .Where(x => x.Email == command.UserName)
    .FirstOrDefault();

var user = _documentSession
    .Load<IUser>("users/" + command.UserName);

This also produces results but does not get both in one trip to the database:

var result = _documentsSession
    .Query<MessageStatisticResult, MessageSummaryByUserIndex>()
    .Customize(x => x.Include("users/" + command.UserName))
    .Where(x => x.Email == command.UserName)
    .FirstOrDefault();

var user = _documentSession
    .Load<IUser>("users/" + command.UserName);

回复收藏 0 原文