Difference between datareader and dataset?
- 26 Answers
- 62657 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
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
How to generate a single aggregate?
What is ado oledb and odbc?
How to enable and disable connection pooling?
What is a dynaset in access?
Which is faster entity framework or ado.net?
Explain all the classes those are used for database connections between sql server and asp.net?
What is ado.net connection?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
What is difference between entity framework and ado.net?
What are the pre-requisites for connection pooling?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
What is a datareader object?
What are the data providers in ADO.NET framework?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
