从收到的数据存储过程中填充自定义C#对象

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

List<CustomObject> customObjects = new List<CustomObject>();

for (int i = 0; i < 10; i++)
{
    CustomObject customObject = new CustomObject
    {
        Id = i,
        Name = $"Name {i}",
        Age = i * 10
    };

    customObjects.Add(customObject);
}

public List<CustomObject> GetCustomObjectsFromDatabase()
{
    List<CustomObject> customObjects = new List<CustomObject>();

    // 在这里执行数据库查询，以获取数据
    // 假设您已经获取了一个名为dataReader的SqlDataReader对象
    using (SqlDataReader dataReader = GetDataFromDatabase())
    {
        while (dataReader.Read())
        {
            CustomObject customObject = new CustomObject
            {
                Id = dataReader.GetInt32(0),
                Name = dataReader.GetString(1),
                Age = dataReader.GetInt32(2)
            };

            customObjects.Add(customObject);
        }
    }

    return customObjects;
}