[NHibernate]存储过程的使用（三）

create proc [dbo].[ps_Search]
  @CustomerID uniqueidentifier
as
begin
  select * from TB_Customer
  where CustomerID=@CustomerID
  end 

1   <!--需要和class节点同一级别-->
2   <sql-query name="ps_Search" >
3    <return class="Wolfy.Shop.Domain.Entities.Customer,Wolfy.Shop.Domain" />
4     exec ps_Search :CustomerID
5   </sql-query>

 1         /// <summary>
 2         /// 使用存储过程，进行查询
 3         /// </summary>
 4         /// <returns></returns>
 5         public IList<Customer> SearchCustomerByIDUsingProc(Guid customerID)
 6         {
 7             ISession session = NHibernateHelper.GetSession();
 8             //参数为映射文件中为<sql-query>节点指定的name
 9 
10             return session.GetNamedQuery("ps_Search")
11                 .SetGuid("CustomerID", customerID)
12                 .List<Customer>();
13         }

1 exec sp_executesql N'exec ps_Search @p0',N'@p0 uniqueidentifier',@p0='DDF63750-3307-461B-B96A-7FF356540CB8'

1 ALTER proc [dbo].[ps_Search]
2   @CustomerID uniqueidentifier
3 as
4 begin
5   select  CustomerName from TB_Customer
6   where CustomerID=@CustomerID
7   end 

  <!--需要和class节点同一级别-->
  <sql-query name="ps_Search" >
   <!--<return class="Wolfy.Shop.Domain.Entities.Customer,Wolfy.Shop.Domain" />-->
    <return-scalar column="CustomerName" type="String"/>
    exec ps_Search :CustomerID
  </sql-query>

 1         /// <summary>
 2         /// 使用存储过程，进行查询
 3         /// </summary>
 4         /// <returns></returns>
 5         public string SearchCustomerNameUsingProc(Guid customerID)
 6         {
 7             ISession session = NHibernateHelper.GetSession();
 8             //参数为映射文件中为<sql-query>节点指定的name
 9             return session.GetNamedQuery("ps_Search")
10                 .SetGuid("CustomerID", customerID).UniqueResult().ToString();
11         }