微软企业库 5 启用事务回滚

            SqlDatabase db  =   new  SqlDatabase( @" server=.\sql2008;uid=sa;pwd=123456;database=DBTEST " );

             using  (DbConnection connection  =  db.CreateConnection())
            {
                 // 打开链接
                connection.Open();
                 // 创建事务
                DbTransaction Tran  =  connection.BeginTransaction();
                 try
                {

                    db.ExecuteNonQuery(Tran, CommandType.Text,  " Insert Into TLog (DEC) Values('123') " );
                    db.ExecuteNonQuery(Tran, CommandType.Text,  " Insert Into TLog (DEC) Values('124') " );
                    db.ExecuteNonQuery(Tran, CommandType.Text,  " Insert Into TLog (DEC) Values(125) " );
                     // 提交事务
                    Tran.Commit();
                }
                 catch  (Exception Ex)
                {
                     // 出错回滚
                    Tran.Rollback();
                    Console.WriteLine(Ex.ToString());
                }
                 finally
                {
                     // 关闭连接
                    connection.Close();
                }

                Console.WriteLine( " OK " );
                Console.ReadKey();
            }

 

不要忘记在执行时加入“Tran”，否则不起做用的