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


Please Help Members By Posting Answers For Below Questions

Explain the advantages and disadvantages of using datalist?

616


What are the benefits of ADO.NET?

607


What is fill method in ado.net?

543


How to find the given query is optimised one or not?

508


What is ado.net full form?

558






Define Execute Scalar?

553


What is the difference between ado.net and oledb?

483


What is the full form of ado?

516


What is isolation?

571


What two types of data providers does ADO.NET supply? What determines which one you should use?

538


What is meant by executenonquery?

529


Do you use stored procedure in ado.net?

546


What is connection in ado.net?

532


Describe the command object and its method.

524


How can we add/remove row's in "datatable" object of "dataset"?

539