如何在C#中回滚查询？

using System;
using System.Data.SqlClient;

public class Program
{
    static void Main()
    {
        string connectionString = "YourConnectionStringHere"; // 替换为你的数据库连接字符串
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            
            SqlTransaction transaction = connection.BeginTransaction(); // 开始事务
            
            try
            {
                using (SqlCommand command = connection.CreateCommand())
                {
                    command.Transaction = transaction; // 关联命令到事务
                    
                    // 执行SQL操作
                    command.CommandText = "INSERT INTO Table1 (Column1) VALUES ('Value1')";
                    command.ExecuteNonQuery();
                    
                    // 假设这里有一个错误
                    throw new Exception("模拟错误");
                    
                    // 更多的数据库操作...
                }
                
                transaction.Commit(); // 如果一切正常，则提交事务
            }
            catch (Exception ex)
            {
                Console.WriteLine("发生错误: " + ex.Message);
                transaction.Rollback(); // 发生错误时回滚事务
            }
        }
    }
}