Difference between datareader and dataset?
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
What is ado code?
What are disadvantages of microsoft-provided data provider classes in ado.net?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What are the steps you will take to improve performance? Will you use dataset or datareader?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
Explain advantages of ado.net?
Explain why edit is not possible in repeater?
What DataReader class do in ADO.NET ?
What is maximum pool size in ado.net connection string?
What is ole data type?
What is ado.net full form?
Which name space is used to get assembly details?
What does datareader object do?
Do we use stored procedure in ADO.Net?