Difference between Data Reader and Data Set

DATA READER V/S DATA SET:-

DATA READER: -

1. Data Reader is directly connected to database system i.e works in connected mode.

2. Data Reader can hold one table at a time.

3. No Local storage is required.

4. It occupies less memory.

5. No XML storage available.If data does not need to be modified, cached or serialised consider using a reader.

DATA SET:-

1. Data Set is generally used to employ disconnected architecture of ADO.Net. It works in disconnected mode.

2. Data Set can hold multiple tables at a time. It represents a computer set of data including related tables, constraints and relationships among the tables.

3. It reads data from database and stores in local system.

4. It occupies more memory.

5. Can be stored as XML.