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

What is a cloud service, What is a Cloud Service? A cloud service is us...

What is a Cloud Service? A cloud service is used to build cloud applications. This service gives the facility of using the cloud application without installing it on the comput

Describe the three levels of data abstraction, Describe the three levels of...

Describe the three levels of data abstraction? The are three levels of abstraction: Physical level: The lowest level of abstraction explains how data are stored.  Logical

Explain the concept of bookmarks in wf 4.0, Explain the concept of Bookmark...

Explain the concept of Bookmarks in WF 4.0. In WF 4.0, a bookmark is a mechanism that enables an activity to wait for an input without interrupting a workflow thread. When an a

API''s, i would like to learnd API''s how they works for advance programmin...

i would like to learnd API''s how they works for advance programming in vb.net

Data base management, 1. What are the limitations of file based data storin...

1. What are the limitations of file based data storing techniques?

Costing, how much u guys cost for 5 pages website in .net?

how much u guys cost for 5 pages website in .net?

DOT NET., How to Learn Dot Net Online and get online certificate ?

How to Learn Dot Net Online and get online certificate ?

Calculating the sum of digits - c# program, Calculating the Sum of Digits -...

Calculating the Sum of Digits - C# Program Hi, Can any of you, tell me how can i calculate the sum of digits of a given number?

Use of resource manager class, What's the use of resource manager class? ...

What's the use of resource manager class? The ResourceManager class helps us to read the resource files and get the values by using key. At First you require to create the obje

Types of compatibility in vb6, What are types of compatibility in VB6 T...

What are types of compatibility in VB6 There are three possible project compatibility settings: No Compatibility Project Compatibility Binary Compatibility

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