Difference between datareader and dataset?
Answer Posted / sridhar.m
Data reader
1. It is a read only and forward only data.
2. U can access one table at time.
3. It can't persist the data.
4. It is comes under connected architecture.
5. One of the most advantage is it is much faster than data
adapter
6.datareader connection oriented.
Data set:
1. It is defined with multiple tables.
2. It can persist the data.
3. It is a relational data cache hosted in application
domain during execution.
4. It is a disconnected architecture.
5. It can't defined with out data adapter.
6.whereas dataset disconnected.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is ado connection?
What is aggregating data ?
What is difference between Dataview and Datatable?
What is a data control clerk?
What does ole stand for in excel?
What is the role of the dataset object in ado.net?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is DataRowCollection?
What are the types of databinding?
Which property is used to check whether a DataReader is closed or opened?
Define Execute Reader?
What is namespace in ado.net?
What is ole in excel?
What is ado or jdbc?
What are the advantages using ado.net?