nHibernate对未映射实体计数
|
使用nHibernate 2。
在我们的系统中，我们有一个表，用于存储可能指向系统中其他任何表的记录以及一些其他字段。例如
class PointerTable
{
public int ID;
public string ObjectName;
public int RecordID;
... additional fields
}
select a.ID, e.Field1, a.Field2, a.Field3,
count(select *
from PointerTable p
where p.ObjectName = \"Table1\"
and p.RecordID = a.ID)
from Table1 a
where a.ParentTable.ID = :ID
<bag name=\"PointerRecords\" table=\"PointerTable\" lazy=\"true\" inverse=\"true\">
<key>
<column name=\"ThisEntityID\" />
<column name=\"ObjectName\" /> ?? Hard coded
</key>
<one-to-many class=\"PointerTable\" not-found=\"ignore\"/>
</bag>
select a.ID, e.Field1, a.Field2, a.Field3, Count(d.ID)
from Table1 a
inner join Table2 e on a.ParentID=e.ID
left outer join PointerTable d on d.ObjectName = \'Table1\' and d.RecordID = a.ID
where c.ID = @ID
group by a.ID, e.Field1, a.Field2, a.Field3
没有找到相关结果
已邀请:
1 个回复
渐首洽陈染
public SomeEntityMap(){ Table(\"SomeTable\"); HasMany(x => x.PointerRecords) .Table(\"PointerTable\") .KeyColumn(\"ThisEntityID\") .Where(\"ObjectName = \'SomeTable\'\") }<bag name=\"PointerRecords\" table=\"PointerTable\" lazy=\"true\" inverse=\"true\" where =\"ObjectName = \'SomeTable\'\"> <key column=\"ThisEntityID\"/> <one-to-many class=\"PointerTable\" not-found=\"ignore\"/> </bag>object[] results = session.CreateCriteria<SomeEntity>() .Add(Restrictions.Eq(\"Id\", id)) .SetProjection(Projections.ProjectionList() .Add(Projections.Property(\"Field1\")) ... .Add(Projections.Count(\"PointerRecords\"))); .List()var entities = session.CreateCriteria<SomeEntity>() .Add(Restrictions.Eq(\"Id\", id) .SetFetchMode(\"PointerRecords\", NHibernate.FetchMode.Eager) .List<SomeEntity>(); entities[0].PointerRecords.Count