How can i convert sqlDatareader to List<>

Question

Possible Duplicate:
How can I easily convert DataReader to List<T>?

I want to return list which will store the sqldatareader value. how can i do this..

Answer 1

using (var reader = cmd.ExecuteReader())
{
    var result = new List<Foo>();
    while (reader.Read())
    {
        var foo = new Foo 
        {
            Prop1 = reader.GetInt32(0),
            Prop2 = reader.GetString(1),
        }
        result.Add(foo);
    }
}

Answer 2

Also check this previously asked qestion : How can I easily convert DataReader to List<T>?

Check this for generic type :

public ConvertToList<T>(SqlDataReader sqldr, int index)
        {
            List<T> list = new List<T>();

            while (sqldr.Read())           {
               list.Add((T)sqldr.GetValue(index));               index++;   
            }

            return list;
        }

Answer 3

Old discussion, but try this on for size.

Strongly type your fields, and cast your rows into a DbDataRecord object. ex:

                    Dim _Query = (From row In _Results.Cast(Of DbDataRecord)().AsParallel()
                            Select New uTyping.Profile() With {
                                .Id = row(0),
                                .Firstname = row(6)
                            }).ToList()