使用C#将数据表转换为嵌套列表/对象

using System;
using System.Collections.Generic;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        // 假设连接字符串为"connectionString"，数据表名为"tableName"
        string connectionString = "YourConnectionString";
        string tableName = "YourTableName";

        // 连接到数据库并查询数据表
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            SqlCommand command = new SqlCommand($"SELECT * FROM {tableName}", connection);
            SqlDataReader reader = command.ExecuteReader();

            // 创建嵌套列表/对象的数据结构
            List<Dictionary<string, object>> nestedList = new List<Dictionary<string, object>>();

            // 遍历数据表的每一行数据
            while (reader.Read())
            {
                // 创建一个字典来存储当前行的数据
                Dictionary<string, object> row = new Dictionary<string, object>();

                // 遍历每一列的数据，并将列名和对应的值存储到字典中
                for (int i = 0; i < reader.FieldCount; i++)
                {
                    string columnName = reader.GetName(i);
                    object columnValue = reader.GetValue(i);
                    row[columnName] = columnValue;
                }

                // 将当前行的字典添加到嵌套列表中
                nestedList.Add(row);
            }

            // 输出转换后的嵌套列表/对象
            foreach (Dictionary<string, object> row in nestedList)
            {
                foreach (KeyValuePair<string, object> column in row)
                {
                    Console.WriteLine($"{column.Key}: {column.Value}");
                }
                Console.WriteLine();
            }
        }
    }
}