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"

Web application as well as site design & development .net, Web application ...

Web application as well as site design & development (.NET) We are interested in retentive the services of a solution provider that will design and implement the presentation la

How does cas works, How does CAS works? There are two key methods of CA...

How does CAS works? There are two key methods of CAS security policy- code groups and permissions. A code group contains assemblies in it in a manner that each .NET assembly is

C#, . write a program for displaying the total no of characters, words and ...

. write a program for displaying the total no of characters, words and sentences in a given file

What is the meaning of object pooling, What is the meaning of object poolin...

What is the meaning of object pooling? Object pooling is a method of storing a pool (group) of objects in memory that can be reused later as needed. Whenever, a new object is n

Difference in stored procedure and user defined function, What is the diffe...

What is the difference between Stored Procedure (SP) and User Defined Function (UDF)? Some of major differences between a stored procedure and user defined are as follows:-

Name the binders provided by .net framework 4.0, Name the binders provided ...

Name the binders provided by .NET Framework 4.0. .NET Framework 4.0 provides the following binders: Object Binder - Enables to communicate with .NET objects. JavaScrip

MVC, how can we use entity framework in ASP.Net MVC

how can we use entity framework in ASP.Net MVC

I want help to make clone a website, I want help to make Clone a Website -d...

I want help to make Clone a Website -dior.com I want all features of above mentioned site 1)Effects 2)Mobile optimization for mobile browsers of all smart phones. Etc.

Design a integrated application, This assignment aims to give you a deeper...

This assignment aims to give you a deeper understanding of a 3-tiers integrated application, which groups together several topics taught in this course. This assignment asks yo

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