Share via


Working with DataReaders 

You can use the ADO.NET DataReader 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. Using the DataReader can increase application performance both by retrieving data as soon as it is available, and (by default) storing only one row at a time in memory, reducing system overhead.

Each .NET Framework data provider included with the .NET Framework has a DataReader object: the .NET Framework Data Provider for OLE DB includes an OleDbDataReader object, the .NET Framework Data Provider for SQL Server includes a SqlDataReader object, the .NET Framework Data Provider for ODBC includes an OdbcDataReader object, and the .NET Framework Data Provider for Oracle includes an OracleDataReader object.

In This Section

Reference

  • DbDataReader
    Describes the DbDataReader class and all of its members.
  • SqlDataReader
    Describes the SqlDataReader class and all of its members.
  • OleDbDataReader
    Describes the OleDbDataReader class and all of its members.
  • OdbcDataReader
    Describes the OdbcDataReader class and all of its members.
  • OracleDataReader
    Describes the OracleDataReader class and all of its members.

See Also

Other Resources

Connecting and Retrieving Data in ADO.NET