连接嵌套查询 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 方法来内部联接到该子查询。
请参阅这篇文章有关 QueryOver API 的更多详细信息。