阻止在transaction C#中进行更新的SQL Server锁

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

    using (SqlTransaction transaction = connection.BeginTransaction())
    {
        try
        {
            SqlCommand command = connection.CreateCommand();
            command.Transaction = transaction;

            // 设置锁的级别为Serializable
            command.CommandText = "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE";
            command.ExecuteNonQuery();

            // 执行更新操作
            command.CommandText = "UPDATE TableName SET ColumnName = NewValue WHERE Condition";
            command.ExecuteNonQuery();

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