将sql查询转换为nhibernate [英] Convert sql query into nhibernate

问题描述

请将sql查询转换为nhibernate查询。我的查询如下：



SQL查询：



SELECT tbl_other_related_family .record_id

，tbl_other_related_family.related_record_id

FROM tbl_record

INNER JOIN tbl_other_related_family

ON tbl_other_related_family.record_id = tbl_record。 record_id

INNER JOIN tbl_record AS relatedrecord

ON relatedrecord.record_id = tbl_other_related_family.related_record_id

WHERE tbl_record.isactive = 1

AND relatedrecord.isactive = 1



Nhibernate查询：



ICriteria MyCriteriaOtherRelated = NHibernateHttpModule.CurrentSession.CreateCriteria（typeof（TblRecordVO），Record）

.CreateAlias（TblOtherRelatedRecordFamily，Family，NHibernate.SqlCommand.JoinType.LeftOuterJoin）;





我不知道如何再次加入tbl_record表格。



请h elp我将查询转换为nhibernate。

Please convert sql query into nhibernate query. My query is given below.

SQL Query:

SELECT tbl_other_related_family.record_id
,tbl_other_related_family.related_record_id
FROM tbl_record
INNER JOIN tbl_other_related_family
ON tbl_other_related_family.record_id = tbl_record.record_id
INNER JOIN tbl_record AS relatedrecord
ON relatedrecord.record_id = tbl_other_related_family.related_record_id
WHERE tbl_record.isactive = 1
AND relatedrecord.isactive = 1

Nhibernate Query:

ICriteria MyCriteriaOtherRelated = NHibernateHttpModule.CurrentSession.CreateCriteria(typeof(TblRecordVO), "Record")
.CreateAlias("TblOtherRelatedRecordFamily", "Family", NHibernate.SqlCommand.JoinType.LeftOuterJoin);


I don't know that how to join the table "tbl_record" again.

Please help me to convert query into nhibernate.

推荐答案

这篇关于将sql查询转换为nhibernate的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！