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 ado recordset?

691


Which object needs to be closed?

1999


Describe datareader object of ado.net with example.

708


What is ado.net architecture?

688


What is data adapter in ado.net with example?

715


Is it possible to edit data in Repeater control?

706


What is the difference between statement and preparedstatement interface?

776


What are the usages of the command object in ado.net?

773


What is a sqldataadapter?

759


Which is faster ado.net or linq?

773


Does sqlclient and oledb class share the same functionality?

723


What is disconnected architecture in ado.net?

734


How to check if the Dataset has records ?

743


Name which operations can you not perform on an ado.net dataset?

718


What is ado data control?

750