如何在C#中将数据表中的大量行插入到列表中

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

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString";
        string query = "SELECT * FROM YourTable";

        List<YourObject> dataList = new List<YourObject>();

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            connection.Open();

            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                YourObject data = new YourObject();
                data.Column1 = reader.GetString(0); // Assuming Column1 is a string
                data.Column2 = reader.GetInt32(1); // Assuming Column2 is an int

                dataList.Add(data);
            }

            reader.Close();
        }

        // Now you have the data in the dataList
        foreach (YourObject data in dataList)
        {
            Console.WriteLine(data.Column1 + " - " + data.Column2);
        }
    }
}

public class YourObject
{
    public string Column1 { get; set; }
    public int Column2 { get; set; }
}