C# MySQL DBHelper事务回滚

C# MySQL DBHelper事务回滚

public static bool Add(List<T> list)
{
 string conn="连接字符串";
 using (MySqlConnection myConn = new MySqlConnection(conn))
 {
   myConn.Open();
   //创建事务 并且启动
   MySqlTransaction transaction = myConn.BeginTransaction();
   try
   {
     string masterSQL= string.Format("主表新增语句");
     MySqlCommand cmd = new MySqlCommand(masterSQL, myConn);
     bool success = cmd.ExecuteNonQuery() > 0;
     if (success)
     {
        //获取主表新增成功自增ID
        long id = cmd.LastInsertedId;
        for(int i = 0; i < list.Count; i++)
        {
         string fromSQL = string.Format("从表新增语句");
         MySqlCommand cmd2 = new MySqlCommand(fromSQL , myCon);
         bool success2 = cmd2.ExecuteNonQuery() > 0;
         if (!success2)
         {
            //回滚事务
            transaction.Rollback();
            return false;
         }
        }
        //全部新增完成,提交事务
        transaction.Commit();
        return true;
     }
     else
     {
     //主表新增失败，无需回滚
     }
   }
   catch (Exception ex)
   {
     transaction.Rollback();
     return false;
   }
  }
}