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

Ask an Expert

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

Write your message here..

Related Questions

Explain the difference between xml and html., Explain the difference betwee... Explain the difference between XML and HTML. XML explains data while HTML describes how the data should be displayed. Thus, HTML is about displaying information while XML is ab

Gmail, how make the google sign up page? how make the google sign up page?

What is asp.net authentication providers and iis security, What is ASP.NET ... What is ASP.NET Authentication Providers and IIS Security? ASP.NET executes authentication using authentication providers, which are code modules that determine credentials and

I want to develop a windows 8.1 application, I want to develop a Windows 8.... I want to develop a Windows 8.1 Application Project Description: Media Player App Development for Windows 8.1 platform with brilliant UI, flexible controls and easy to use.

Explain the xml elements, Explain the XML elements. The elements are th... Explain the XML elements. The elements are the central units of an XML document that define and identify data. The elements are represented by the tags. You can also make your

What is machine.config, What is Machine.config?  Machine configuration ... What is Machine.config?  Machine configuration file: The machine. config file have settings that apply to the entire computer. This file is located in the %runtime install path

C# Microsoft Solver Foundation, I have a code in C# which uses Microsoft So... I have a code in C# which uses Microsoft Solver Foundation to solve linear programming model. But the problem is the code is too long, there are too many variables and constraints,

Metrics followed in project management, What are the metrics followed in pr... What are the metrics followed in project management? The most metric sets deal with a variation of these attributes and are chosen to help the project managers gain insight int

Fake webcam application, I need a program that mimics the similar functiona... I need a program that mimics the similar functionality as the link below. Program must have a unique user interface. Must add source code, installer, and of course a nice user i

Capstone .., Why isn''t there an allowed amount for nonfacility for code 27... Why isn''t there an allowed amount for nonfacility for code 27405?