What is a datareader object, DOT NET Programming

Assignment Help:

What is a DataReader object?

The DataReader object helps in retrieving the data from a database in a forward-only, read-only mode. The base class for all the DataReader objects is the DbDataReader class.

The DataReader object is returned as a result of calling the ExecuteReader() method of the Command object. The DataReader object enables faster retrieval of data from databases and increases the performance of .NET applications by giving rapid data access speed. However, it is less preferred as compared to the DataAdapter object because the DataReader object requires an Open connection till it completes reading all the rows of the specified table.

 

An Open connection to read data from large tables consumes most of the system resources. When multiple client applications at the same time access a database by using the DataReader object, the performance of data retrieval and other related processes is substantially decreased. In such a case, the database might refuse connections to other .NET applications unless other clients free the resources.

 


Related Discussions:- What is a datareader object

How to code reviews?, How will you do code reviews? The way in which th...

How will you do code reviews? The way in which the code reviews are done change from person to person and also from company to company. But generally when a project is started

What is the difference between int and int32, What is the difference betwee...

What is the difference between int and int32. There is no difference among int and int32. System.Int32 is a .NET Class and int is an alias name for System.Int32.

What is the datacontext class, What is the DataContext class and how is it ...

What is the DataContext class and how is it related to LINQ? After you add a LINQ to SQL Classes item to a project and open the O/R Designer, the empty design surface shows an

Explain assemblies, Explain assemblies An assembly is a single deployab...

Explain assemblies An assembly is a single deployable unit that having all the information about the implementation of : - classes - structures and - interfaces An

Explain windows authentication schemes, Explain Windows authentication Sche...

Explain Windows authentication Schemes There are four parts of windows authentication I. Integrated Windows authentication II. Basic and basic with SSL authentication

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?

Application for online game, Introduction This assignment aims to give yo...

Introduction This assignment aims to give you a "real world experience" that occurs far too often in the workplace. You have been hired to complete as much as possible a project

Difference between delegate and events, What is the difference between dele...

What is the difference between delegate and events? Actually events use delegates in the bottom. But they also add an extra layer on the delegates, hence forming the publisher

Dynamic web presentation tier, Part 1 requires you to complete a dynamic we...

Part 1 requires you to complete a dynamic web presentation tier, based on your MiddlewareLib.dll  library. This should run as an ASP.NET page, Default.aspx, under WebDev.WebServer,

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