On rare occasions SqlDataReader returns stale data from a previous query. We read the columns of a SELECT statement sequentially using ExecuteReader and the corresponding Get operations, eg.

I'm having trouble populating a List<T> using SQLDataReader. The problem is that will I can see it iterate through the rows during the while loop, the list adds the next row but over rights the ...

I am just curios, in the generated code, why do you get the field values by ordinal number instead of using the field names? I assume that it's faster, but how much faster? Did you run any tests? let ...