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

 1 USE [Shop]
 2 GO
 3 --|--------------------------------------------------------------------------------
 4 --| [TB_CustomerInsert] - Insert Procedure Script for TB_Customer
 5 --|--------------------------------------------------------------------------------
 6 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id (N'[dbo].[TB_CustomerInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[TB_CustomerInsert]
 7 GO
 8 
 9 CREATE PROCEDURE [dbo].[TB_CustomerInsert]
10 (
11     @CustomerID uniqueidentifier OUTPUT,
12     @CustomerName nvarchar(16) = NULL,
13     @CustomerAddress nvarchar(128) = NULL,
14     @Version int
15 )
16 AS
17     SET NOCOUNT ON
18 
19     INSERT INTO [TB_Customer]
20     (
21         [CustomerID],
22         [CustomerName],
23         [CustomerAddress],
24         [Version]
25     )
26     VALUES
27     (
28         NEWID(),
29         @CustomerName,
30         @CustomerAddress,
31         @Version
32     )
33 
34     RETURN @@Error

    <!--存储过程，check参数：none/rowcount/param-->
    <sql-delete>exec TB_CustomerDelete ?</sql-delete>

 1         /// <summary>
 2         /// 通过存储过程方式删除客户信息
 3         /// </summary>
 4         /// <param name="customer"></param>
 5         /// <returns></returns>
 6         public bool DeleteCustomerByIDWithProcedure(Customer customer)
 7         {
 8             var session = NHibernateHelper.GetSession();
 9             using (ITransaction trans = session.BeginTransaction())
10             {
11                 try
12                 {
13                     session.Delete(customer);
14                     session.Flush();
15                     trans.Commit();
16                     return true;
17                 }
18                 catch (Exception)
19                 {
20                     trans.Rollback();
21                     throw;
22                 }
23             }
24         }

 1 ALTER PROCEDURE [dbo].[TB_CustomerDelete]
 2 (
 3     @CustomerID uniqueidentifier
 4 )
 5 AS
 6     --SET NOCOUNT ON
 7 
 8     DELETE 
 9     FROM   [TB_Customer]
10     WHERE  
11         [CustomerID] = @CustomerID
12 
13     RETURN @@Error

 1 ALTER PROCEDURE [dbo].[TB_CustomerDelete]
 2 (
 3     @CustomerID uniqueidentifier,
 4     @Version int
 5 )
 6 AS
 7     --SET NOCOUNT ON
 8 
 9     DELETE 
10     FROM   [TB_Customer]
11     WHERE  
12         [CustomerID] = @CustomerID and [Version]=@Version
13 
14     RETURN @@Error

    <!--存储过程，check参数：none/rowcount/param-->
    <sql-delete check="rowcount" >exec TB_CustomerDelete ?</sql-delete>

exec sp_executesql N'exec TB_CustomerDelete @p0',N'@p0 uniqueidentifier,@p1 int',@p0='3727A133-C079-4DF9-B31E-7625B03F95DF',@p1=1

  <sql-delete>DELETE FROM [TB_Customer] WHERE [CustomerID] = ? and [Version] =?</sql-delete>

exec sp_executesql N'DELETE FROM [TB_Customer] WHERE [CustomerID] = @p0 and [Version] =@p1',N'@p0 uniqueidentifier,@p1 int',@p0='64C35DEE-84D9-4C2D-ABAF-7D53631E3EAA',@p1=1