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 the difference between a datareader and a dataset?
What is acid in ado.net?
What is basic use of data view?
Define atomicity?
Do we use stored procedure in ADO.Net?
What is a sqldataadapter?
What is a serialized object?
What is a datareader object?
What is the difference between DataReader and DataSet in ADO.NET?
Define Execute Scalar?
How to check if a datareader is closed or opened? IsClosed()
How to add an aggregate column?
What are the different ado.net namespaces?
How to generate a single aggregate?
Which is faster datareader or dataadapter?