Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 66487 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / anju
- 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 ? | 14 Yes | 6 No |
Post New Answer View All Answers
How can we add/remove row's in "datatable" object of "dataset"?
What are the major difference between classic ADO and ADO.NET?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
What are the different row versions available in table?
What is Dataset Object?
What is ado or jdbc?
How do you update a dataset in ado.net and how do you update database through dataset?
How to connect and retrieve data from database using dataset
What is the difference between Optimistic and Pessimistic locking?
What is the return type of executescalar?
What is sqlconnection and sqlcommand?
Does dapper use ado.net?
Explain the difference between data reader and data adapter?
Does entity framework use ado.net?
What is ado control?
