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
Define Execute Reader?
What is sqldatareader in ado.net?
How do you implement locking concept for dataset?
What are advantages of microsoft-provided data provider classes in ado.net?
What is Serialization in .NET? what are the types of Serialization?
What are the data providers in ADO.NET framework?
What is the difference in record set and dataset?
What is variable view?
Which object holds only data and does not interact with data source?
What is ado circle?
Describe the disconnected architecture of ADO.NET’s data access model.
What is connection pooling and what is the maximum pool size in ado.net connection string?
What are the ado.net connection pooling parameters?
Explain the advantage of ADO.Net?
What is the full form of ado.net?