如何将 HQL 结果转换为 List其中 T 是映射类

Question

我有这个 nhibernate 查询：

var q =
               NHibernateSession.Current.CreateSQLQuery
               (
                    @"SELECT  LastestEvents.*
                    FROM    (
                            SELECT  DISTINCT SbQcontainer.Container
                            FROM    HistoricEvents
                            SbQcontainer WHERE SbQcontainer.LineCompany_Id = :lineCompany) as Sbq
                             JOIN HistoricEvents as  LastestEvents
                    ON      LastestEvents.id = (
                            SELECT TOP(1) id
                            FROM    HistoricEvents mi
                            WHERE   mi.Container = Sbq.Container and mi.LineCompany_Id = :lineCompany
                            ORDER BY mi.Date DESC
                            )"
               ).SetResultTransformer(Transformers.AliasToBean(typeof(HistoricEvent)));

            q.SetParameter("lineCompany",lineCompany.Id);
            q.SetCacheable(false);

            var results = q.List<HistoricEvent>().ToList();

它查找给定 lineCompany 的每个容器上的最新事件，它有效，但我不知道如何将此结果集设置为 T HistoricEvent 列表，我尝试这一行：

.SetResultTransformer(Transformers.AliasToBean(typeof(HistoricEvent)));

但抛出 NHibernate.PropertyNotFoundException：无法在类“HistoricEvent”中找到属性“Event_Id”的设置器。

有什么方法可以做到这一点吗？或者可以使用 ICriteria API 执行相同的查询？

提前谢谢。

Answer 1

假设 HistoricEvent 是一个映射实体，以下内容应为您提供所需内容：

var q = 
               NHibernateSession.Current.CreateSQLQuery 
               ( 
                    @"SELECT  LastestEvents.* 
                    FROM    ( 
                            SELECT  DISTINCT SbQcontainer.Container 
                            FROM    HistoricEvents 
                            SbQcontainer WHERE SbQcontainer.LineCompany_Id = :lineCompany) as Sbq 
                             JOIN HistoricEvents as  LastestEvents 
                    ON      LastestEvents.id = ( 
                            SELECT TOP(1) id 
                            FROM    HistoricEvents mi 
                            WHERE   mi.Container = Sbq.Container and mi.LineCompany_Id = :lineCompany 
                            ORDER BY mi.Date DESC 
                            )" 
               ).AddEntity(typeof(HistoricEvent)); 

            q.SetParameter("lineCompany",lineCompany.Id); 
            q.SetCacheable(false); 

            var results = q.List<HistoricEvent>().ToList(); 

请参阅 相关文档了解更多详细信息。