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 are all features of ADO.Net?
What is Data Provider?
How to connect and retrieve data from database using dataset
Explain ODP.net
Which namespaces are used for data access?
What are the essential features of ado.net?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Explain why edit is not possible in repeater?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
How to creating a SqlCommand Object?
What are the parameters that control most of connection pooling behaviors?
What are the methods of XML dataset object?
What is executenonquery ado.net?
What are the types of databinding?
What is acid in ado.net?