从表到列表的C# SQL记录

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

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

        List<User> userList = new List<User>();

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

            while (reader.Read())
            {
                User user = new User();
                user.Id = Convert.ToInt32(reader["Id"]);
                user.Name = reader["Name"].ToString();
                user.Age = Convert.ToInt32(reader["Age"]);

                userList.Add(user);
            }

            reader.Close();
        }

        foreach (User user in userList)
        {
            Console.WriteLine("Id: " + user.Id + ", Name: " + user.Name + ", Age: " + user.Age);
        }
    }
}

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