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 use of SqlCommand object?
What is datasource in ado.net?
What is a string variable?
What is connection in ado.net?
What is Data view?
How can we load multiple tables in a dataset?
Describe connection object in ado.net
What are the advantages of ado.net?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
What is untyped dataset?
What is difference between executequery and executeupdate?
How to Read, Add, Update and Delete record in Entity Framework ?
Which object needs to be closed?
What is dbcontext and dbset in entity framework?