What is difference between dataset and data reader?

 Posted by ArticlesMaint on 9/16/2009 | Category: ADO.NET Interview questions | Views: 7991

Answer: -
Following are some major differences between dataset and data reader:-

• Data Reader provides forward-only and read-only access to data, while the Dataset object can hold more than one table (in other words more than one row set) from the same data source as well as the relationships between them.

• Dataset is a disconnected architecture while data reader is connected architecture.

• Dataset can persist contents while data reader cannot persist contents, they are forward only.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response