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 is the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc

982


What is the difference between client-side and server-side validations in ASP.NET?

1115


Disable browser cache for entire ASP.NET website?

1132


What are the differences between primary foreign and unique keys?

1009


Explain the different parts that constitute ASP.NET application?

968


What are the different ways you would consider sending data across pages in ASP (i.e between asp to asp)?

925


Describe the disadvantage of cookies.

974


Explain what is viewstate?

940


Explain a program using code nuggets to create a simple application? : asp.net mvc

974


If you have an application with multiple security levels though secure login and my ASP.NET web appplication is spanned across three web-servers by using round-robbin load balancing. Explain which is the best approach to maintain login-in state for the users?

1045


What is skin in asp.net?

904


Is there any alternative to avoid name collisions other then Namespaces?

1069


How do you do Client-side validation in .Net?

1040


List the asp.net validation controls?

897


What is application and session in asp.net?

900