• +91 9723535972
  • info@interviewmaterial.com

Ado.net Interview Questions and Answers

Question - Differentiate DataSet and DataReader.

Answer -

DataSet

DataReader

DataSet provides read/write access to data, so we can update the data.

DataReader provides read-only access to data, so we can’t update the data.

It has a disconnected architecture, which means the data obtained from the database can be accessed even after the database connection was closed.

It has a connected architecture, which means to access the data retrieved from the database, the connection must be opened.

It supports various database tables from different databases.

It supports only a single table from a single database.

It provides slower access to data due to overhead.

It provides faster access to data.

Both forward and backward scanning of data is possible.

Only forward scanning of data is possible.

Comment(S)

Show all Coment

Leave a Comment




NCERT Solutions

 

Share your email for latest updates

Name:
Email:

Our partners