Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

which one is faster execute reader, scalar, execute non
query ?

Answer Posted / vikas kant

1.Execute scalar is most fastest bcoz it returns only
single value.

2.Afterwards Execute reader bcos it reads data in forward
only or read only mode as well as has the live connection
with the database.

3.At last Execute Non Query bcoz it makes the changes in
database.

Execute Scalar ---> Execute Reader ----> Execute Non Query.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the Types of state management techniques

992


What is server side in asp.net?

949


Which property is used to identify the Page is Post Back in ASP.NET?

985


What is state management technique?

965


Describe session handling in a webfarm, how does it work and what are the limits?

1044


Is it possible for me to change my aspx file extension to some other name?

971


What is jade template engine?

1006


Why do we use datasource in asp.net?

932


Is asp.net core faster?

982


Explain diff. Betn dataset and recordset?

960


can we remote debug applications with the remote debugger installed with vs.net 2002, with vs.net 2003?

2111


How can I create master page in asp net?

915


Which browsers support the xmlhttprequest object?

959


Explain repository pattern in asp.net mvc? : asp.net mvc

996


What is the use of session?

909