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 2:51:11 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

Can you give a practical implementation of FAÇADE patterns? The Façade pattern sits on the top of lot of the subsystems & makes access easy to interfaces of these subsystems. T

What is a workflow? A workflow is a collection of actions (called activities) that presents the model of a process. A workflow gives a way to explain the order of the execution

I need help figuring out how to capture text box values from C# ASP.NET and send them from one class to another after being processed by a method.

What is XML Text Reader? The "XmlTextReader" class helps to give fast access to streams of XML data in a forward-only and read-only manner. The XMLTextReader also checks if the

What is aspect oriented programming? The Aspect-oriented software development is the latest technology for the separation of the concerns (SOC) in the software development. The

Develop a Face Recognition Systems Project Description: Seeking for someone who has worked with Face Recognition techniques and is familiar with the relevant mathematical alg

What is scavenging? When server running your ASP.NET application runs low on the memory resources, items are discarded from the cache depending on cache item priority. The Cach

Have you ever worked with Microsoft Application Blocks, if yes then which? The Application Blocks are C# & the VB.NET classes distributed as the Visual Studio projects which ca

The Cache object is always defined in the System.Web.Caching namespace. You can get the reference to the Cache object by either using the Cache property of the HttpContext class in