Working with DataReaders and DataAdapters

DataReaders and DataAdapters are core objects of a data provider. These are some of the most important features that ADO.NET provides. Let's see how to work these objects.

DataReaders

Every provider has DataReaders. Underneath, all classes do the same thing. SqlDataReader, OdbcDataReader, and OleDbDataReader all implement the IDataReader interface. The main use of DataReader is to read data from a data source when it is coming from a stream. Let's take a look at the different properties that a data reader has:

Property	Description
Depth	The depth of nesting for a row
FieldCount	Returns the number of columns in a row
IsClosed	Returns TRUE if DataReader...