What is the difference between Datareader and Dataset?

Answer

Following table gives difference between Datareader and Dataset:

Datareader:-

Forward only

Connected Recordset

Single table involved

No relationship required

No XML storage

Occupies Less Memory

Read only

Dataset:-

Loop through Dataset

Disconnected Recordset

Multiple tables involved

Relationship between tables maintained

Can be stored as XML

Occupies More memory

Can do addition / Updation and Deletion

 

All ado.net Questions

Ask your interview questions on ado-net

Write Your comment or Questions if you want the answers on ado-net from ado-net Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---