Difference between datareader and dataset?
Answer Posted / chaitanya k
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
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.
Is This Answer Correct ? | 121 Yes | 12 No |
Post New Answer View All Answers
What is the functionality of data provider in ado.net?
What is difference between connected and disconnected architecture in ado.net?
What is disconnected scenario in entity framework?
What is connection string?
Explain the overview of ado.net architecture?
Can datareader hold data from multiple tables?
What is the current version of entity framework?
Define the data provider classes that is supported by ado.net?
How is it possible to get 2 tables of data at a time by using data reader?
Which object needs to be closed?
What is the difference between data reader and data adapter?
What is the use of ADO.NET and XML web services?
What are the steps to connect to a database?
What are the several execute methods of ado.net?
Define data adapter?