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
.NET aplication with vBulletin paid subscribtion Project Description: I have an application in .net it's a simple client i have sheltered with net seal license system for aut

Reflection All .NET assemblies have metadata information stored  the types defined in the modules. And This metadata information can be accessed by mechanism called as "Reflect

Write a C# program (C# console application) that plays a word game with the user. The program should ask the user to enter the following: • His or her name • His or her age

Fixing chrome problem Problem 1- Booksearcha.asp and bookrstep2.asp on allreaders.com (bookrstep2 only accessible from bookrstep1.asp) utilize scroll down menus at times. In Chr

What is the difference between thread and process?  Thread - is used to implement more than one program at a time. process - implements single program A thread is a path

What is Microsoft Intermediate Language (MSIL)? The .NET Framework is shipped with compilers of all .NET programming languages to develop programs. There are separate compilers

What are abstract classes? What are the distinct characteristics of an abstract class? An abstract class is a class that cannot be instantiated and is always used as a base cla

What is impersonation in ASP.NET? By default, the ASP.NET executes in the security context of a restricted user account on the local machine. Sometimes you require to access ne

Project Description: We're seeking an IT candidate with experience to help us optimizely,  Skills required: .NET, C# Programming, ASP, eCommerce, SQL