Nhibernate DetachedCriteria 子查询上的左外连接

发布于 2024-08-03 01:48:58 字数 808 浏览 2 评论 0原文

我只会尝试呈现问题的主要部分，因为整个情况要复杂得多 - 我无法使用 DetachedCriteria 实现以下目标

SELECT *
FROM User
LEFT OUTER JOIN GroupItem
ON User.ID = GroupItem.UserID
AND _groupItemRestrictions_

可以有多个 GroupDefinitions，用户可以属于多个 GroupItems，每个 GroupItems 属于它自己组定义。由于分页/排序和（多级）组行为的一些复杂原因，我无法使用此查询实现适当的分页行为：

SELECT *
FROM User
LEFT OUTER JOIN GroupItem
ON User.ID = GroupItem.UserID
WHERE _groupItemRestrictions_

类似于第二个查询的查询是这样生成的：

var criteria = DetachedCriteria.For<User>()
...
GroupItem groupItem = null;
criteria.CreateAlias(() => groupItemAlias, () => groupItem,
                                                JoinType.LeftOuterJoin);
criteria.Add(Restrictions.Or(...));
...

是否可以使用 DetachedCriteria 创建第一个查询？

谢谢！

原文

I'll only try to present the main part of the problem, because the whole situation is much more complicated - I am unable to achieve the following with DetachedCriteria

SELECT *
FROM User
LEFT OUTER JOIN GroupItem
ON User.ID = GroupItem.UserID
AND _groupItemRestrictions_

There can be multiple GroupDefinitions, User can belong to multiple GroupItems which each belong to it's own GroupDefinition. Due to some complicated reason with paging/sorting and (multilevel) group behavior, I cannot achieve appropriate paging behavior with this query:

SELECT *
FROM User
LEFT OUTER JOIN GroupItem
ON User.ID = GroupItem.UserID
WHERE _groupItemRestrictions_

A query similar to the second one is produced this way:

var criteria = DetachedCriteria.For<User>()
...
GroupItem groupItem = null;
criteria.CreateAlias(() => groupItemAlias, () => groupItem,
                                                JoinType.LeftOuterJoin);
criteria.Add(Restrictions.Or(...));
...

Is it possible to create the first query with DetachedCriteria?

Thanks!

分享到QQ

分享到微博