What do you think about Caching DataReader in Cach object? Do you think it is acceptable, and why?

Post

View All

Moses Soliman

What do you think about Caching DataReader in Cach object? Do you think it is acceptable, and why?

By Moses Soliman in ASP.NET on Aug 23 2006

0
6.1k
1

Post Your Answer

Aug, 2006 23
It is not good to cache a DataReader object, and so, it is not acceptable.

DataReader is a read only forward only recordset of data. Once it a record is read, you can't get back to, As so, it is useless to cache DataReaders.
- 0