如何在C# dotnet中将HierarchyId转换为子/父(树)结构？

using System;
using System.Data;
using System.Data.SqlClient;

public class HierarchyIdConverter
{
    private string connectionString = "YourConnectionString";

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

            string query = "SELECT HierarchyIdColumn.ToString() AS NodeId, HierarchyIdColumn.GetAncestor(1).ToString() AS ParentId FROM YourTable";

            SqlCommand command = new SqlCommand(query, connection);
            SqlDataReader reader = command.ExecuteReader();

            DataTable dataTable = new DataTable();
            dataTable.Load(reader);

            // Convert HierarchyId to tree structure
            TreeNode root = new TreeNode();
            ConvertToTree(dataTable, root, null);

            // Use the tree structure
            // ...

            reader.Close();
        }
    }

    private void ConvertToTree(DataTable dataTable, TreeNode currentNode, string parentId)
    {
        DataRow[] rows = dataTable.Select("ParentId = '" + parentId + "'");

        foreach (DataRow row in rows)
        {
            string nodeId = row["NodeId"].ToString();
            string currentId = row["CurrentId"].ToString();

            TreeNode newNode = new TreeNode(nodeId);
            currentNode.Children.Add(newNode);

            ConvertToTree(dataTable, newNode, nodeId);
        }
    }
}

public class TreeNode
{
    public string NodeId { get; set; }
    public List<TreeNode> Children { get; set; }

    public TreeNode(string nodeId)
    {
        NodeId = nodeId;
        Children = new List<TreeNode>();
    }
}