将DataReader转换为C#对象

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

public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
}

public class DataReaderToObjectConverter
{
    public List<Person> ConvertDataReaderToObject(SqlDataReader reader)
    {
        List<Person> persons = new List<Person>();

        while (reader.Read())
        {
            Person person = new Person();
            person.Id = reader.GetInt32(0);
            person.Name = reader.GetString(1);
            person.Age = reader.GetInt32(2);

            persons.Add(person);
        }

        return persons;
    }
}

public class Program
{
    public static void Main()
    {
        string connectionString = "your_connection_string";
        string query = "SELECT Id, Name, Age FROM Persons";

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

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

                DataReaderToObjectConverter converter = new DataReaderToObjectConverter();
                List<Person> persons = converter.ConvertDataReaderToObject(reader);

                foreach (Person person in persons)
                {
                    Console.WriteLine($"Id: {person.Id}, Name: {person.Name}, Age: {person.Age}");
                }
            }
        }
    }
}