ADO.Net Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1839 Page Views: 

What is the difference between DataSet and DataReader?



Posted By: Avi Date: 6 October 2009 05:47:03 AM
 Answer:

Following are some major differences between DataSet and DataReader:

1) DataReader provides forward-only, read-only access to data, while the DataSet object can hold more than one table from the same data source as well as the relationships between them.

2) DataSet is a disconnected architecture while DataReader is connected architecture.

3) DataSet can persist contents while DataReader cannot persist contents, they are forward only.


Posted By: eTechPlanet


Date: 6 October 2009 05:47:03 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image NGRlU9
Related Questions
ADO.Net : What is the difference between DataSet and DataReader?

What is the difference between DataSet and DataReader?

Following are some major differences between DataSet and DataReader: 1) DataReader provides forward....
Category: ADO.Net Date: 10/6/2009 5:47:03 AM
ADO.Net : What is a DataReader object?

What is a DataReader object?

DataReader object provides a read-only, forward-only stream of data from a database. The DataReader ....
Category: ADO.Net Date: 10/6/2009 5:35:46 AM
ADO.Net : What are the advantages of ADO.Net?

What are the advantages of ADO.Net?

ADO.Net offers following benefits: 1) XML is the format for transmitting datasets across the networ....
Category: ADO.Net Date: 10/6/2009 5:17:57 AM
ADO.Net : What do you mean by Data Providers?

What do you mean by Data Providers?

ADO.Net relies on Data Providers to provide access to a particular data source. Each Data Provider e....
Category: ADO.Net Date: 9/30/2009 3:59:34 AM
ADO.Net : What do you mean by DataSet object?

What do you mean by DataSet object?

DataSet object is an in-memory, relational data representation. The DataSet object contains a collec....
Category: ADO.Net Date: 9/12/2009 7:26:46 AM