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 ado or jdbc?
What are the types of databinding?
Explain the dataadapter class in ado.net?
What is dbcontext and dbset in entity framework?
What is the advantage of ado.net?
What is sqldatareader in ado.net?
Explain how to find the given query is optimised one or not?
What is variable view?
What is ole db and odbc?
What is ado and rdo?
Which is better entity framework or ado.net?
What is dataset object? Explain the various objects in dataset.
What is executequery?
What is the significance of CommandBehavior.CloseConnection ?
What are the connected and disconnected modes in ado.net?