Difference between "dataset" and "datareader", DOT NET Programming

What is the difference between "DataSet" and "DataReader"?

The major differences between "DataSet" and "DataReader" are as follows:-

1)The "DataSet" is a disconnected architecture, while the "DataReader" has live connection while reading the data. If we want to cache a data and pass it to a different tier the "DataSet" forms the best choice and it has decent XML support.

2)When application require to access data from more than one table the "DataSet" forms the best choice.

3)If we need to move back while reading records, the "datareader" does not support this functionality.

4)But one of the biggest drawbacks of the DataSet is speed. As the "DataSet" carry considerable overhead as of relations, multiple tables etc speed is slower than "DataReader". Therefore always try to use the "DataReader" wherever possible, as it is meant specially for the speed performance.

Posted Date: 9/24/2012 5:16:06 AM | Location : United States







Related Discussions:- Difference between "dataset" and "datareader", Assignment Help, Ask Question on Difference between "dataset" and "datareader", Get Answer, Expert's Help, Difference between "dataset" and "datareader" Discussions

Write discussion on Difference between "dataset" and "datareader"
Your posts are moderated
Related Questions
A Super-hero SharePoint developer with great design skills Project Description: US: Our start-up company prepares a very innovative and cool SharePoint related product with c

I Need paypal and urolator pro api integrated in to aspx site Project Description: Need paypal and urolator pro api integrated in to aspx site. The is presently completed and

What are major events in GLOBAL.ASAX file? The Global.asax file, which is derived from the HttpApplication class, maintains a pool of the HttpApplication objects, & assigns the

Finding Average of Array Elements - C# Program I need assignment help for Finding Average of Array Elements in C#. Can anybody send me there ideas?

Explain different software development life cycles. The System Development Life Cycle (SDLC) is the overall process of developing information systems through multi stage proces

What is a Hash Table? You can access an array using the INDEX value of that array, but how many times you know the real value of the index. The Hashtable provides a way of acce

What is BCP utility in SQL SERVER? The Bulk Copy Program (BCP) is a command line utility by which you can import & export large amounts of data in and out of the SQL SERVER dat

What are the naming conventions required for XML elements tags? The following are the naming conventions that need to be followed for XML elements tags: Element names should

Create page website to catalog some of the music: A homepage:  that automatically comes up when you go to 127.0.0.1:3000 (instead of the default Ruby-on-Rails pa

Question: (a) Outline four classes that allow you to work with File Streams. (b) (i) What potential problem can arise when you change items stored in an Application State