ADO.NET Dataset vs DataReader


DataSet and DataReader are called fundamental objects of ADO.net as they are used to store data and make it available for .net application and they have the following differences.

Differences Between DataSet and DataReader


DataSet

DataReader

 

 

It  is  disconnected  object  and  can  provide

It is connected object and can not provide

access  to  data  even  when  connection  to

access to data when connection to database

database was closed.

was closed.

 

 

It can store data from multiple tables

It can store data from only one table.

 

 

It allows insert, update and delete on data

It  is  read  only  and  it  doesn’t  allow  insert,

 

update and delete on data.

 

 

It  allows  navigation  between  record  either

It  allows  only  forward  navigation  that  also

forward or backward.

only to immediate next record.

 

 

It can contain multiple records.

It can contain only one record at a time.

 

 

All  the  data  of  a  dataset  will  be  on  client

All  the  data  of  a  DataReader  will  be  on

system.

server and one record at a time is retrieved

 

and stored in datareader when you call the

 

Read() method of datareader.