Difference between datareader and dataset?

Answer Posted / abhijeet kumar sharma

DataReader is faster for read data.DateReader is readonly
propurse,DataReader read data between reader Read() and
close() methods.When we read data from database help of
DataReader then database connection is must open.

DataSet is disconnected architecture. We store multiple
data at a time in dataset.

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

751


Define data adapter?

704


Give an example of a .net application which connects to microsoft access database using ado.net classes.

807


What is the difference between linq and ado.net?

737


How to perform sorting on a table in ADO.NET?

768


how can implement dropdownlist in particular of dataset when try to update?

2538


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

778


What is ado control?

712


What are all the classes that are available in System.Data Namespace?

780


What is dbcontext and dbset in entity framework?

694


What is ado object model?

705


What is a serialized object?

729


What is the difference between ado.net and entity framework?

786


Explain the difference between an ado.net dataset and an ado recordset?

785


How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

734