Difference between datareader and dataset?
Answer Posted / ankur
data reader is connection oriented.it can access only one
value from the database.but the advantage is that it is
faster that dataset operation.
dataset is disconnected.using dataset you can access any
number of values. it can't be used without data adapter.
dataset can contain any number of tables and it maintain
the relationship between tables. when you refesh the
dataset then the changes affect the database
| Is This Answer Correct ? | 16 Yes | 16 No |
Post New Answer View All Answers
What is the hierarchy of data in databases?
What does executenonquery () method return?
Give few examples of datareader that is used in different dataproviders.
What provider ado.net use by default? Explain the role of data provider in ado.net?
How many major types of connection objects in ADO.NET?
What is ado data control?
Which database is the ado.net?
What is connection pooling and what is the maximum pool size in ado.net connection string?
What is csdl entity framework?
What is disconnected architecture in ado.net?
What is the full form of ado?
What is the current version of entity framework?
What is the difference between OLEDB Provider and SqlClient?
Define bubbled event?
What are the steps you will take to improve performance? Will you use dataset or datareader?