C# 中的事务

直接用SQL语句创建事务, 当然不是什么稀奇事了, 好是好, 只是麻烦.

看看C#中怎么做吧:

SqlTransaction Tran = DBConn.BeginTransaction();
cmdTmp.Transaction = Tran;
try
{
    cmdTmp.CommandText = "DELETE FROM xxx";
    cmdTmp.ExecuteNonQuery();
            
    cmdTmp.CommandText = "INSERT INTO  xxx";
    cmdTmp.ExecuteNonQuery();

    Tran.Commit();
}
catch (Exception ex)
{
    Tran.Rollback();
    throw ex;
}
finally
{
    Tran.Dispose();
    cmdTmp.Transaction = null;
}