17.8.txt

《Microsoft Visual C# .NET 2003开发技巧大全》源代码

Listing 17.8 Using TransactionOption for Transactions
[WebMethod(Description=”This is a transaction sample.”,
TransactionOption=TransactionOption.RequiresNew)]
public void DeleteValueByID( int ID )
{
string firstCmdString = “DELETE FROM TestTable WHERE ID=’” + ID + “‘“ ;
string secondCmdString = “DELETE FROM NonExistentTable WHERE ID=’” + ID + “‘“;
SqlCommand firstCmd = new SqlCommand(firstCmdString, sqlConnection1);
SqlCommand secondCmd = new SqlCommand(secondCmdString, sqlConnection1);
// execute first product deletion
firstCmd.Connection.Open();
firstCmd.ExecuteNonQuery();
// execute second command. When this throws an exception then the
// first command is automatically rolled back since we’re
// participating in a transaction
secondCmd.ExecuteNonQuery();
sqlConnection1.Close();
}