nhibernate GetNamedQuery function

hbm.xml mapping [function]

　　<!-- fnGetListOfChildSector -->
    <sql-query name="fnSalesGetRegroupmentsByParents" resultset-ref="SalesRegroupments">

        <return class="Application.Core.BusinessObjects.Sales.SalesRegroupments" />

        <![CDATA[       
         select * from dbo.fn_Sales_GetRegroupmentsByParents(:ParentIds)   
        ]]>

    </sql-query>

Class using :

　　　　　　var salesRegroupmentsList = this.Session.GetNamedQuery("fnSalesGetRegroupmentsByParents")
                    .SetParameter("ParentIds", ids)
                    .SetResultTransformer(
                        new NHibernate.Transform.AliasToBeanConstructorResultTransformer(
                            typeof(SalesRegroupments).GetConstructors()[1]
                            )
                    ).List<SalesRegroupments>();

//很实用的方法哦

hbm.xml :

    <!-- fnSalesGetYears -->
    <sql-query name="fnSalesGetYears" >
        <![CDATA[       
            select distinct Year from dbo.Sales_Brique
        ]]>
    </sql-query>

cs file:

　　　　　　IQuery query = this.Session.GetNamedQuery("fnSalesGetYears");
                 var years = query.List<string>().ToList<string>();

转载于:https://www.cnblogs.com/yubuaishui/archive/2011/03/10/1980032.html