Difference between datareader and dataset?
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
What is ole in excel?
What are the advantage of ado.net?
Explain the advantages and disadvantages of using datalist?
What is the use of SqlCommand object?
How to Read, Add, Update and Delete record in Entity Framework ?
How can we add relation between tables in a dataset?
What is ado net stands for?
What are datareaders?
What is dbcontext and dbset in entity framework?
How do you implement locking concept for dataset?
What is ado.net architecture?
What are the ado.net objects?
What is the difference between a datareader and a dataset?
What is the role of the dataset object in ado.net?
What is ado rdo dao in visual basic?