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 bubbled event can you please explain?
What is data control techniques?
What are the Features of a dataset
Define partial class?
What is the use of SqlCommand object?
Define different execute methods of ADO.NET command object ?
What are the rules to implement connection pooling?
What do you know about ado.net's methods?
What are all the commands used with Data Adapter?
What is meant by executenonquery?
What is the usage of the dataset object in ado.net?
Define the data provider classes that is supported by ado.net?
Give few examples of datareader that is used in different dataproviders.
What is the full form of ado.net?
What are the namespaces used in ADO.Net to connect to a database?