NHibernate - 从sql函数返回复杂对象

// 定义SQL函数
public class GetComplexObject : SQLFunction
{
    public GetComplexObject()
    {
        super("get_complex_object", new String[]{"id"}, new Type[] {StandardBasicTypes.INTEGER});
    }

    public String render(Type firstArgumentType, List arguments, SessionFactoryImplementor factory)
    {
        return "get_complex_object(" + arguments.get(0) + ")";
    }
}

// 在HQL中调用SQL函数
String hql = "SELECT get_complex_object(id) FROM ComplexObject WHERE id = :id";
Query query = session.createQuery(hql);
query.setParameter("id", 1);
ComplexObject complexObject = query.uniqueResult();

// 在原生SQL中调用SQL函数
String sql = "SELECT get_complex_object(id) FROM ComplexObject WHERE id = :id";
Query query = session.createSQLQuery(sql);
query.addScalar("get_complex_object", new GetComplexObject());
query.setParameter("id", 1);
ComplexObject complexObject = query.uniqueResult();