sqldatareader

[Jeremy Chapman]

The most efficient way to get a recordset out of sql server is probably by
using a sqldatareader. I want to make a generic class that I can populate
with data from a datareader (an extremely slimmed down datatable, with less
functionality I suppose). Essentially it would store an array of arrays of
objects, and a list of column names. The classes data would all be
populated by passing a sqldatareader to a method of the class. This class
would have to be able to be efficiently stored in asp.net viewstate/session
and be quickly iterated through. What kind of data structures would you
guys suggest to accomplish holding this type of data?

 

[Cor Ligthert [MVP]]

Jeremy,

I am curious, why is what you write efficient I see only inefficiency in
your text.

You describes how to make a wheel, only it is as massive wheel as the first
ones.

Just my thought,

Cor