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

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

Explain the concept of web services in brief, Explain the concept of Web se...

Explain the concept of Web services in brief. A Web service may be explained as an independent and self-sustained unit of a software application that is hosted on the Web and i

Steps to create a windows service in vb.net, What are the steps to create a...

What are the steps to create a windows service in VB.NET ? The Windows Services are long-running executable applications that run in its own Windows session, which then has the

Management, read a file which has emp.no,name,age as per fields/you want to...

read a file which has emp.no,name,age as per fields/you want to calculate no.of employess whose age more than50

Textile pro, Could not find any resources appropriate for the specified cul...

Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "Textilepro.frmLogin.resources" was correctly embedded or linked into assembly

Use of hidden frames to cache client data, How can you use Hidden frames to...

How can you use Hidden frames to cache client data? This technique is implemented by developing a Hidden frame in page which will have your data to be cached. T cols="100

Cookies, #question.cookies working with data.

#question.cookies working with data.

Application object and its difference from cache object, What is an applica...

What is an application object & how it is different from c ache object? The Application object can be used in many situations where we want the data to be shared across user

Printing and adding fibonacci series - c# program, Printing and adding Fibo...

Printing and adding Fibonacci series - C# Program Hello guys i need your advice. How can i print and add Fibonacci series in my project. Please recommend some examples.

Develop one web based application, Project Description: Specifically i n...

Project Description: Specifically i need develop one web based application which have student registration and according to semester and each time it will change as per semester

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