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

Assignment Help:

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.


Related Discussions:- Difference between "dataset" and "datareader"

Why does an organization need to manage the workloads, Why does an organiza...

Why does an organization need to manage the workloads? The workload can be explained as an independent service or a set of code that can be implemented. It can be everything f

Connect a software application to a database backend, Connect a Software Ap...

Connect a Software Application to a Database Backend Acquire the knowledge and develop the skills needed to prototype an end user application using a rapid application dev

What happens when aspx page is requested from browser ?, The steps that occ...

The steps that occur when we request a ASPX page are as follows:- 1) The browser sends the request to the webserver. Now  assume that the webserver at the other end is IIS. 2

What is the difference between the take and skip clauses, What is the diffe...

What is the difference between the Take and Skip clauses? The Take clause returns a specified number of elements. For instance, you can use the Take clause to return two values

What is a manifest, What is a Manifest?  An assembly manifest have all ...

What is a Manifest?  An assembly manifest have all the metadata needed to specify the assembly's version requirements and security identity, and all metadata required to define

I need a custom report - crystal reports, I need a Custom Report - Crystal ...

I need a Custom Report - Crystal Reports Project Description: I am seeking a custom report for our syrinx hire software, all reports are made from Crystal Reports. Skills

Application that tracks production costuming, The costumer is an applicatio...

The costumer is an application that tracks production costuming, structure and other related pieces. We discussed this in detail and you have commentary and video to define the pro

Prepare an application in c# or c++, Prepare an Application in C# or C++ ...

Prepare an Application in C# or C++ Project Description: We are seeking someone who can write a program in C# or C++. The concept is to develop the program using a Cross P

Indexes, What are indexes? The Indexes in the SQL Server are similar to...

What are indexes? The Indexes in the SQL Server are similar to the indexes in books. They help SQL Server to retrieve the data quickly.These are classified into clustered and n

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd