Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 67558 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 will you fill the gridview by using datatable object at runtime?
What we do with the object of ado.net dataset after using it?
Which architecture does Datasets follow?
Is it possible to load multiple tables in a Dataset?
Explain the difference between data reader and data adapter?
Give an example that shows how to execute a stored procedure in ado.net?
What is an orm, and why would you use one instead of plain old ado.net?
What is microsoft ado?
Give few examples of datareader that is used in different dataproviders.
What is the difference between linq and ado.net?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
Explain the difference between ado and ado.net?
What is the role of data provider in ado.net?
Can we do database operations without using any of the ado.net objects?
What are three methods for displaying data in a syncfusion datagrid
