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 an ADO.Net?
What are all features of ADO.Net?
What is the difference between Optimistic and Pessimistic locking?
If we are not returning any records from the database, which method is to be used?
What is difference between Dataview and Datatable?
Can you explain how to enable and disable connection pooling?
What is data reader in ado.net?
Explain how to find the given query is optimised one or not?
What is ado.net object model?
What is the DataTableCollection?
Why do we serialize data?
What is the difference between data reader and data adapter?
Which method is used by command class to execute SQL statements that return single value?
What is a serialized object?
What is ado and rdo?