我可以从SqlConnection对象获取对待处理事务的引用吗？

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Server=myServerAddress;Database=myDatabase;User Id=myUsername;Password=myPassword;";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            SqlCommand command = connection.CreateCommand();
            SqlTransaction transaction;

            // 开始事务
            transaction = connection.BeginTransaction("SampleTransaction");

            // 将 SqlCommand 与事务关联
            command.Transaction = transaction;

            try
            {
                // 在此处执行您的数据库操作
                command.CommandText = "INSERT INTO MyTable (Column1, Column2) VALUES ('Value1', 'Value2')";
                command.ExecuteNonQuery();

                // 提交事务
                transaction.Commit();
            }
            catch (Exception ex)
            {
                // 发生错误时回滚事务
                Console.WriteLine("Error: " + ex.Message);
                transaction.Rollback();
            }
        }
    }
}