Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between datareader and dataset?
- 26 Answers
- 67511 Views
- Microsoft, Noel Infotech, Satyam, Value Labs, I also Faced
- E-Mail Answers
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
Which database is the ado.net?
What is the use of SqlCommandBuilder?
What are the difference between readonly vs. Const?
How to add a check box or a dropdown list to a column in a datagrid?
What is the difference between data reader and data adapter?
What you mean by filtering of data?
What is the use of connection object in ado.net?
What does ado stand for?
Define atomicity?
Which control of the BindingNavigator returns the current position within the data source?
What is the current version of entity framework?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is a column variable?
What are the Features and disadvantages of dataset
Does sqlclient and oledb class share the same functionality?
