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 sqlconnection and sqlcommand?
How to create data relations?
What is the usage of the dataset object in ado.net?
Why is stored procedure used in ado.net?
What is commandbuilder in ado.net?
How does ado.net work?
What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What is disconnected architecture in ado.net?
What are the essential features of ado.net?
What is ado.net objects?
How to store data in memory?
What is ole used for?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
How do you find the count of records in a dataset?
What is the difference in record set and dataset?