.net中TransactionScope的使用

 

TransactionScope类表示一个事务范围，位于该范围内的代码块都成为一个事务，在调用TransactionScope类中定义的Complete方法时将结束并提交事务。

引用命名空间:using System.Transactions;

using (TransactionScope tx = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromSeconds(180)))

{

//连接数据库的字符串

                string ConnectionString = @"Data Source = ./sqlexpress; Initial Catalog = Northwind; Integrated Security = SSPI;";

                 //创建数据库连接类实例

                SqlConnection conn = new SqlConnection(ConnectionString);

                //创建三个数据库SqlCommand命令类实例

                SqlCommand command1 = new SqlCommand(@"DELETE FROM Shippers WHERE CompanyName LIKE 'Test Ship%'", conn);

                SqlCommand command2 = new SqlCommand(@"INSERT Shippers(CompanyName,Phone) VALUES('Test Ship1','0000-0001')", conn);

                SqlCommand command3 = new SqlCommand(@"INSERT Shippers(CompanyName,Phone) VALUES('Test Ship2','0000-0002')", conn);

                try

                {

                    conn.Open();//打开数据库

                    command1.ExecuteNonQuery();//执行查询

                    command2.ExecuteNonQuery();

                     command3.ExecuteNonQuery();

                    tx.Complete();

                }

                finally

                {

                    if (conn.State == ConnectionState.Open)

                    {

                        conn.Close();//关闭数据库

                    }

                }

}