SqlDataReader convert to List without loop

Question

I can convert SqlDataReader to a list using a loop While(dr.Read()).

But, I need to convert SqlDataReader to a list.

Pseudo code:

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();

Class:

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

See : http://stackoverflow.com/questions/1464883/how-can-i-easily-convert-datareader-to-listt — S.K, Jul 30 '15 at 06:28

score 1 · Answer 1 · answered Jul 30 '15 at 06:46

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();
  }
}

answered Jul 30 '15 at 06:46

Santosh Yadav

41
1
7

a `while` loop here would look more elegant. – Amit Kumar Ghosh Jul 30 '15 at 07:20
1

@AmitKumarGhosh but the question was to do it without the loop – TK-421 Sep 17 '20 at 12:53

SqlDataReader convert to List without loop

1 Answers1