如何在list<class>中存储SqlDataReader的值？

public class MyClass
{
    public int Id { get; set; }
    public string Name { get; set; }
    // 其他属性...
}

List<MyClass> myList = new List<MyClass>();

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

    while (reader.Read())
    {
        MyClass obj = new MyClass();
        obj.Id = Convert.ToInt32(reader["Id"]);
        obj.Name = reader["Name"].ToString();
        // 设置其他属性...

        myList.Add(obj);
    }

    reader.Close();
}

foreach (MyClass obj in myList)
{
    Console.WriteLine("Id: " + obj.Id);
    Console.WriteLine("Name: " + obj.Name);
    // 访问其他属性...
}