nhibernate - 加入嵌套查询 NHibernate

Question

如何在 NHibernate 中使用条件或 QueryOver 执行此查询？

select r.relationshipidentifier, r.publicrelationshipid
from relationship r 
inner join (
    select max(asofdate) as asofdate, s.relationshipidentifier
    from relationship s
    group by s.relationshipidentifier
) m
on r.asofdate = m.asofdate and r.relationshipidentifier = m.relationshipidentifier

假设

public class Relationship {
    public virtual Guid Id { get; set; }
    public virtual DateTime AsOfDate { get; set; }
    public virtual Guid RelationshipIdentifier { get; set; }
    public virtual Guid PublicRelationshpId { get; set; }
}

Answer 1

内连接可以用子查询来描述。
效果是-

QueryOver.Of<Relationship>()
.SelectList(list =>
    list.SelectMax(r => r.AsOfDate),
    list.GroupProperty(r=> r.RelationshipIdentifier)
)

并且您可以使用 QueryOver 的 WithSubquery 方法来内部连接到该子查询。见this article有关 QueryOver API 的更多详细信息。