Difference between datareader and dataset?
- 26 Answers
- 63006 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
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
Why is stored procedure used in ado.net?
What is difference in record set and dataset?
Can we do database operations without using any of the ado.net objects?
What is ado connection?
What is ole word?
What is the difference between statement and preparedstatement interface?
What is ambient transaction?
What is the difference between OLEDB Provider and SqlClient?
How to connect and retrieve data from database using dataset
What is difference between sqldatareader and sqldataadapter?
List the 4 common ado.net namespaces?
How to read data with the sqldatareader ?
What is ado.net components?
What is a string variable?
What is the role of data provider in ado.net?
