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
Which is faster datareader or dataadapter?
What is Data view?
How to add a javaScript function in a datagrid?
What are the different layers of ado.net?
What is ado data control?
What is ole2 format?
What are all the commands used with Data Adapter?
Explain all the classes those are used for database connections between sql server and asp.net?
What is the difference between ado.net and oledb?
What are the ado.net objects?
Is ado.net an orm?
What are all the different authentication techniques used to connect to MS SQL Server?
Some important instruction regarding ADO.NET connection string ?
What is two way data binding android?
What is a datagridview?