nHibernate 3 QueryOver 与复合 from 子句

发布于 2024-11-04 09:57:32 字数 492 浏览 0 评论 0原文

有谁知道一种使用 nHibernate 3 QueryOver 语法进行复合 from 子句的方法 - 这可以通过 Linq to object 实现。我知道 Linq To nHibernate 可以实现这一点，但我仍在尝试了解 queryover api。

下面是从 msdn 获取 Linq to object 的示例：

var scoreQuery = from student in students
                 from score in student.Scores
                 where score > 90
                 select new { Last = student.LastName, score };

取自 MSDN

原文

Does anybody know a way to do compound from clauses - that are possible with Linq to objects - with nHibernate 3 QueryOver syntax. I know its possible with Linq To nHibernate, but I'm still trying to get my head around the queryover apis.

Here is the example taken from the msdn for Linq to objects:

var scoreQuery = from student in students
                 from score in student.Scores
                 where score > 90
                 select new { Last = student.LastName, score };

Taken from MSDN

分享到QQ

分享到微博

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

发布评论

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

↙温凉少女 2024-11-11 09:57:32

您可以使用 QueryOver API 加入，但我认为您需要使用 Linq to Objects 将结果展平为匿名类型。

像这样的事情：

session.QueryOver<Student> ()
    .JoinQueryOver (s => s.Scores).Where (s => s > 90)
    .Select (s => s.LastName, s => s.Scores)
    .List ()
    .SelectMany (s => s.Scores, (student, score) => new { Last = student.LastName, Score = score });

You can join using the QueryOver API, but I think you'll need to use Linq to Objects to flatten your result into the anonymous type.

Something like this:

session.QueryOver<Student> ()
    .JoinQueryOver (s => s.Scores).Where (s => s > 90)
    .Select (s => s.LastName, s => s.Scores)
    .List ()
    .SelectMany (s => s.Scores, (student, score) => new { Last = student.LastName, Score = score });

回复收藏 0 原文

~没有更多了~