sqldatareader

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?

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

"Jeremy Chapman" <please@Idontlikespam> schreef in bericht
news:eCso8tKlGHA.3924@TK2MSFTNGP03.phx.gbl...
> 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?
>