从 SqlDataReader 创建 JSON 字符串

从 SqlDataReader 创建 JSON 字符串的方法

csharp
using Newtonsoft.Json;
using System;
using System.Data.SqlClient;
class Program
{
    static void Main()
    {
        string connectionString = "Your_Connection_String";
        string query = "SELECT * FROM Your_Table";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            using (SqlCommand command = new SqlCommand(query, connection))
            using (SqlDataReader reader = command.ExecuteReader())
            {
                // 创建一个动态对象集合
                var data = new System.Dynamic.ExpandoObject();
                var collection = new System.Collections.Generic.List();
                while (reader.Read())
                {
                    // 逐行读取数据并将其添加到动态对象中
                    var row = new System.Dynamic.ExpandoObject();
                    for (int i = 0; i < reader.FieldCount; i++)
                    {
                        ((System.Collections.Generic.IDictionary)row)[reader.GetName(i)] = reader[i];
                    }
                    // 将动态对象添加到集合中
                    collection.Add(row);
                }
                // 将集合转换为JSON字符串
                var jsonResult = JsonConvert.SerializeObject(collection);
                Console.WriteLine(jsonResult);
            }
        }
    }
}