Differentiate between DataSet and DataReader

S.No	DataSet	DataReader
1.	Works on loops	Works on forward only
2.	Has disconnected recordsets	Has ample of connected recordsets
3.	Can carry out both addition and deletion	Can perform only read-only activities
4.	Can store XML data	There is no facility for storage of XML data
5.	There are multiple tables involved	Only requires a single table
6.	There must be a relationship between the tables	No relationship between the tables required
7.	Requires more memory space	Requires only less memory space

Related Questions