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 are the advantages and disadvantages of using datalist?
What is ambient transaction?
Explain the difference in an abstract class and an interface?
What is dataset and datatable in ado.net?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
Define Execute Scalar?
How do you implement locking concept for dataset?
Explain what are acid properties?
How to load multiple tables into a dataset?
What is aggregate root?
What is data relation?
What is sql connection in ado.net?
How will you fill the gridview by using datatable object at runtime?
What is the difference between connected and disconnected environment?
What is the use of data grid?