你能在一次交易中拥有多个MySqlCommand吗？

using System;
using MySql.Data.MySqlClient;

namespace MultipleMySqlCommands
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "server=localhost;user=root;password=password;database=test";
            MySqlConnection connection = new MySqlConnection(connectionString);
            connection.Open();

            MySqlCommand command1 = new MySqlCommand("INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')", connection);
            MySqlCommand command2 = new MySqlCommand("INSERT INTO users (name, email) VALUES ('Jane Doe', 'jane@example.com')", connection);

            using (MySqlTransaction transaction = connection.BeginTransaction())
            {
                command1.Transaction = transaction;
                command2.Transaction = transaction;

                command1.ExecuteNonQuery();
                command2.ExecuteNonQuery();

                transaction.Commit();
            }

            connection.Close();
        }
    }
}