Difference between datareader and dataset?

Answer Posted / sagar

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 ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an ADO.Net?

778


What are all features of ADO.Net?

765


What is the difference between Optimistic and Pessimistic locking?

772


If we are not returning any records from the database, which method is to be used?

1035


What is difference between Dataview and Datatable?

767


Can you explain how to enable and disable connection pooling?

757


What is data reader in ado.net?

749


Explain how to find the given query is optimised one or not?

742


What is ado.net object model?

738


What is the DataTableCollection?

828


Why do we serialize data?

725


What is the difference between data reader and data adapter?

806


Which method is used by command class to execute SQL statements that return single value?

795


What is a serialized object?

745


What is ado and rdo?

713