NHibernate 执行存储过程

<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> <sql-query name="GetCustomerOrderHistory"> <return-scalar column="ProductName" type="String" /> <return-scalar column="Total" type="int" /> exec CustOrderHist :CustomerID </sql-query> </hibernate-mapping> public IList<CustOrderHist> getCustOrderHistList ( string customerID ) { IQuery query = session.GetNamedQuery( "GetCustomerOrderHistory" ) .SetString( "CustomerID" , customerID ) .SetResultTransformer(new NHibernate.Transform.AliasToBeanConstructorResultTransformer(typeof( CustOrderHist ).GetConstructors( )[0] )); return query.List<CustOrderHist>( ); }