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

File upload in asp.net, upload files using file upload control to google dr... upload files using file upload control to google drive

What is the difference between dynamic and var data types, What is the diff... What is the difference between dynamic and var data types? The difference among the var and dynamic data types is that the var data type is strongly type checked at the compile

Explain different types of xml application programming, Explain different t... Explain different types of XML Application Programming Interface (API). The following are two main parts of XML parsers: Tree-based API - Compiles an XML document into a tre

Difference between system exceptions and application excepti, What is the d... What is the difference between System exceptions and Application exceptions? All exception is derived from Exception Base class. Exceptions are generated programmatically or ca

Data set and data reader, What is difference between data set and data read... What is difference between data set and data reader? Some major differences between dataset and datareader are as folows :- 1) The DataReader gives forward-only and read-onl

Simple fb integration in ms-sql and asp.net, Simple FB Integration in MS-SQ... Simple FB Integration in MS-SQL and ASP.NET I am seeking urgent project to be done, please I am interested in someone who will present demo for retrieving personal informatio

To know a state of a thread, How can we know a state of a thread? The "... How can we know a state of a thread? The "ThreadState" property is used to get complete detail of a thread. The Thread can have one or a combination of status.System.Threading.

Create a windows application which contain display area, Requirements: ... Requirements: 1.  Complete the following two exercises by developing working csharp projects. 2.  Write a report to explain csharp code written in the projects. 3.  Submi

I need a project which shows paypal integration with asp.net, I need a proj... I need a project which shows Paypal integration with ASP.net website We have events website written in C# and ASP.net. We want to integrate Paypal using API and have a full inte

Accepting a list of 5 items - c# program, Accepting a List of 5 Items - C# ... Accepting a List of 5 Items - C# Program Hello, I've been trying so many codes for this but those codes didn't work well. Please write the code for Accepting a List of 5 Items