Tuesday, 13 August 2013

DataReader in ADO.NET

What it DataReader in ADO.NET?

ADO.NET DataReader is used to retrieve a read-only, forward-only stream of data from a database. Results are returned as the query executes, and are stored in the network buffer on the client until you request them using the Read method of the DataReader.

We cannot perform any insert, update and delete operations in the DataReader.

DataReader is opposite of DataSet.

We cannot move previous in the DataReader.

DataReader requires open connection.

DataReader can hold one table at a time.

DataReader can increase application performance both by retrieving data as soon as it is available, and storin only one row at a time in memory, reducing system overhead.

DataReader have item collection.

A DataReader object is used to sequentially read data from a data source.

No comments:

Post a Comment