nhibernate - 其中一个字段是 count(*) NHibernate

Question

我可以像这样映射查询吗:

select id,name,address,(select count(*) from account where record_id=id ) as counter
from data where id = :id

目前，我使用的是原生 SQL。

class person
{
    public virtual long Id{get;set;}
    public virtual string Name{get;set;}
    public virtual string Address{get;set;}
    public virtual long Counter{get;set;}
}

映射:

<property name="Counter" formula="(select count(*) from account where record_id=id )"      type="long"/>

Answer 1

是的，您应该使用 formula .

您的映射可能如下所示:

<property name="CountOfAccounts"
    formula="(select count(*) from account where account.id = id)"/>