Why DataReader is Forward Only?

Answer Posted / manumole

A DataReader is a stream of data that is returned from a
database query. When the query is executed, the first row
is returned to the DataReader via the stream. The stream
then remains connected to the database, poised to retrieve
the next record. The DataReader reads one row at a time
from the database and can only move forward, one record at
a time. As the DataReader reads the rows from the database,
the values of the columns in each row can be read and
evaluated, but they cannot be edited.

Is This Answer Correct ?    19 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is the best method to get two values from the database?

712


What is ado.net components?

675


What is difference between ado.net and asp net?

733


Define data access layer?

705


Why do we serialize data?

690


What is the difference between ado.net and oledb?

683


How do I delete a row from a DataTable?

764


What is sql connection in ado.net?

686


Which database is the ado.net sql connection object designed for?

801


List the 4 common ado.net namespaces?

864


What are the steps you will take to improve performance?

650


How to copy the contents from one table to another table and how to delete the source table in ado.net?

740


Does dapper use ado.net?

769


How to store data in memory?

687


What are dcl commands?

696