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
What is ado recordset?
Which object needs to be closed?
Describe datareader object of ado.net with example.
What is ado.net architecture?
What is data adapter in ado.net with example?
Is it possible to edit data in Repeater control?
What is the difference between statement and preparedstatement interface?
What are the usages of the command object in ado.net?
What is a sqldataadapter?
Which is faster ado.net or linq?
Does sqlclient and oledb class share the same functionality?
What is disconnected architecture in ado.net?
How to check if the Dataset has records ?
Name which operations can you not perform on an ado.net dataset?
What is ado data control?