asp.net mysql 事务_asp.net中的mysql事务？

我建议使用TransactionScope,因为你可以使用它而不管你正在使用什么数据库.您甚至可以使用它来执行分布式事务(针对同一事务中的多个数据库的操作).

您可以参考代码示例的链接,但一般来说,您这样做：

try

{

using (TransactionScope scope = new TransactionScope())

{

using (MySqlConnection connection1 = new MySqlConnection (connectionString))

{

// Opening the connection automatically enlists it in the

// TransactionScope as a lightweight transaction.

connection1.Open();

// create the DB commands and perform the DB operations

.

.

.

// The Complete method commits the transaction. If an exception has been thrown,

// Complete is not called and the transaction is rolled back.

scope.Complete();

}

}

}

catch (Exception e)

{

// something went wrong, handle the exception accordingly. Note

// that since we did not call TransactionScope.Complete, nothing

// gets committed to the DB.

}