using System.Data.SqlClient;
using System.Transactions;
// 这里写查询代码
// 获取Web.config文件中数据库连接字符串
string connectionString = ConfigurationSettiongs.AppSettings["ConnectionString"];
using(SqlConnection connection = new SqlConnection(connectionString)){
connection.Open();
SqlCommand command = connection.CreateCommand();
SqlTransaction transaction = connection.BeginTransaction();
command.Connection = connection;
command.Transaction = transaction;
try{
//这里写增删改代码
transaction.Commit();
}
catch(Exception e){
transaction.Rollback();
}
finally{
connection.Close();
}
}
注意：此事务方法适合单个数据库使用，若多库请使用分布式显示事务CommittableTransaction
请参考博客.NET事务
