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 : stackoverflow.com/questions/1464883/…

S.K
– S.K

2015-07-30 06:28:07 +00:00
Commented Jul 30, 2015 at 6:28 — S.K
– S.K, Commented Jul 30, 2015 at 6:28

Santosh Yadav · Accepted Answer · 2015-07-30 06:46:14Z

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, 2015 at 6:46

Santosh Yadav

511 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Amit Kumar Ghosh Over a year ago

a while loop here would look more elegant.

TK-421 Over a year ago

@AmitKumarGhosh but the question was to do it without the loop

Collectives™ on Stack Overflow

SqlDataReader convert to List without loop

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related