SQL Command to Typed List

gistfile1.cs

var sqlReader = sqlCommand.ExecuteReader();

var products = new List<Product>();

while(sqlReader.Read())
{
    var product = new Product
    {
        ID = int.Parse(sqlReader["ID"].ToString()),
        Name = sqlReader[1].ToString()
    }
    
    products.Add(product);
}