Diff. b/w DataReader and DataSet?

Answer Posted / tejas mer

DataReader is connected architecture and it's read-only, forward only type, so when you just want to display the data better to use it, it consumes less memory with compare to dataset as well.

DataSet is we can say in-memory representation of the data.
It's disconnected architecture.
Contains DataTables, which are further divided into Datarows and Datacolumns.
Also contains DataRelationships and Contraints...

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages and drawbacks of using ado.net?

636


What is ado net stands for?

532


What is full form of ado?

551


If we are not returning any records from the database, which method is to be used?

772


How can we load multiple tables in to dataset?

577






Explain ado.net features?

552


What is openrowset?

512


List all the steps in order, to access a database through ado.net?

593


What are the different row versions available in table?

541


Explain how to create dynamic gridview?

528


How to create data relations?

560


What are the core objects of ADO.NET?

595


Define Execute Reader?

606


What is execute reader in ado.net?

504


What is csdl entity framework?

567