DataReader
DataReader is used to read the data
from database and it is a read and forward only connection oriented
architecture during fetch the data from database. DataReader is used
to iterate through resultset that came from server and it will read one record at a time because of that memory
consumption will be less and it will fetch the data very fast when compared
with dataset.
DataSet
DataSet
is a disconnected orient architecture that means there is no need of active
connections during work with datasets and it is a collection of DataTables and
relations between tables. It is used to hold multiple tables with data. You can
select data form tables, create views based on table and ask child rows over
relations. Also DataSet provides you with rich features like saving data as XML
and loading XML data.
DataAdapter
DataAdapter
will acts as a Bridge between DataSet and database. This dataadapter object is
used to read the data from database and bind that data to dataset. Dataadapter
is a disconnected oriented architecture.
DataTable:
A DataTable
is an in-memory representation
of a single
database table which has collection
of rows
and columns
DataTable fetches only one TableRow at a time
As DataTable
is a single
database table, so there
is no DataRelation object
in it.
In DataTable, there
is no UniqueConstraint
and ForeignKeyConstraint objects available.
In DataTable, DataSource cannot be serialized.
