SqlDataReader转换为无循环的列表

Question

我可以使用循环While(dr.Read())将SqlDataReader转换为列表。

但是，我需要将SqlDataReader转换为列表。

伪代码:

con.Open();
string sqlBU = "select top 10 fname, iduser from users";
SqlCommand cmd = new SqlCommand(sqlBU, con);
using (SqlDataReader dr2 = cmd.ExecuteReader())
{
    List<ListOfClass> customers = dr2.ToList();
}
dataGridView1.DataSource = lOfClass;
con.Close();

类:

 public class ListOfClass
 {
    public string fname { get; set; }
    public string iduser { get; set; }
 }

Answer 1

var timeSeries = new List<ListOfClass>();  
using (var reader = cmd.ExecuteReader())
{
   if (reader.HasRows)
  {
      timeSeries = reader.Cast<IDataRecord>()
           .Select(r => new ListOfClass
             {
                 fname = (string)r["fname"],
                            iduser = (string)r["iduser"]
             }).ToList();
  }
}