Difference between datareader and dataset?
- 26 Answers
- 62773 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / anju
- Data reader is a connection oriented architecture as its
requires continues connection with Data base.
while Data set is disconnected oriented architecture,
whenever user wants to pull the data he/she build the
connection with Data base.
-Data readers execution is very fast. as it reads only
forward stream.
while
Data set execution is slow as compare to Data reader, as it
carries bundle of data.
- when data changes requires frequently then User should go
for Data set, when user doesn't require data changes
frequently then he/ should go for Data Reader.
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
What are advantages of microsoft-provided data provider classes in ado.net?
What is the hierarchy of data in databases?
What are the differences between OLEDB and SQLClient Providers?
What is oledb connection?
Can we load multiple tables in a dataset?
What is bubbled event can you please explain?
Define table relations?
What are the major difference between classic ADO and ADO.NET?
What is serialization and de-serialization in .net?
What is microsoft ole db provider for sql server?
Explain the difference in an abstract class and an interface?
Does dapper use ado.net?
Why do we serialize data?
Which namespaces are used for data access?
What is ado.net explain with diagram?
