Difference between datareader and dataset?
Answer Posted / chaitanya k
Data reader
1. It is a read only and forward only data.
2. U can access one table at time.
3. It can't persist the data.
4. It is comes under connected architecture.
5. One of the most advantage is it is much faster than data
adapter
Data set:
1. It is defined with multiple tables.
2. It can persist the data.
3. It is a relational data cache hosted in application
domain during execution.
4. It is a disconnected architecture.
5. It can't defined with out data adapter.
| Is This Answer Correct ? | 121 Yes | 12 No |
Post New Answer View All Answers
What is disconnected data?
What are all the commands used with Data Adapter?
What is ado circle?
Explain ado.net features? Benefits? Drawbacks?
How do I delete a row from a DataTable?
Explain the difference between data reader and data set?
What do you know about ADO.NET's objects and methods?
Explain the dataadapter class in ado.net?
Define data access layer?
What are all the classes that are available in System.Data Namespace?
What are the uses of Stored Procedure?
Which is the best method to get two values from the database?
What is Data view?
What is sqldatareader?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?