Difference between DataReader and DataAdapter / DataSet and
DataAdapter?

Answer Posted / anul haq

When accessing data the DataReader is the hands down winner.
Performance increases almost exponentially over the DataSet
when more than a few queries are executed sequentially.


Simple, fast forward, read-only access to result sets is the
DataReader's favorite pastime. If data doesn't need to be
modified, cached or serialized consider using a reader.


Don't dismiss the DataReader just because you need results
in XML. Try using the ExecuteXmlReader method of the
SqlCommand class. Just don't forget the FOR XML clause in
your query.


Business applications with a strong BLL that coerce
requested data into new types can use a DataReader without
fear of lost scalability. Often times the application's
business objects can easily duplicate or enhance some of the
functionality that the DataSet is so popular for. Creating
those business objects can mean the difference between an
application that entirely relies on DataSets to one that can
leverage their usefulness only where need be.


Binding of read-only data is much more efficient using a
reader. Just imagine how many times a day that DropDownList
you use is populated. Remember how much things cost in the
long run.

Is This Answer Correct ?    20 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to retrieve the user id which is provided while windows authentication?

572


Which object is used to add relationship between two Datatables?

553


How is entity framework different from ado.net?

467


Explain the difference in record set and dataset?

470


What is connection pooling and what is the maximum pool size in ado.net connection string?

497






What Is Difference Between Ado And Ado.net?

544


What is sql connection in ado.net?

480


What is the advantage of ado.net?

520


What is a serialized object?

513


Explain what is datagrid with an example?

561


What are the namespaces used in ado.net for data access?

465


What is defaultview in datatable?

517


What is dataadapter in ado.net?

477


What is the difference between Dataset. clone and Dataset.copy?

537


What does executenonquery () method return?

487