Differences between DataSet and DataReader

Answer:

Differences of DataSet and DataReader:

DATASET

1)DataSet is always disconnected from the database.

2)DataSet is like a memory resident database.

3)DataSet can contain temporary tables (DataTables), temporary Views(DataViews), temporary primary keys, temporary Foreign keys

4)DataSet supports forward, backward data navigation.

5)DataSets is used to return data from web service methods since it can be serialized.

6)It can be added in a ToolBox

7)Built in XML support.


DATAREADER

1)DataReader is connected with database(connected architecture)

2)DataReader is likw a forward only cursor used for reading data.

3)DataReader has no temporary tables, views etc,

4)It supports only forward data navigation.

5)It is not returned from web service method as it cannot be searialized.

6)cannot be added in toolbox

7)No built in XML features.