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
What is the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc
What is the difference between client-side and server-side validations in ASP.NET?
Disable browser cache for entire ASP.NET website?
What are the differences between primary foreign and unique keys?
Explain the different parts that constitute ASP.NET application?
What are the different ways you would consider sending data across pages in ASP (i.e between asp to asp)?
Describe the disadvantage of cookies.
Explain what is viewstate?
Explain a program using code nuggets to create a simple application? : asp.net mvc
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?
What is skin in asp.net?
Is there any alternative to avoid name collisions other then Namespaces?
How do you do Client-side validation in .Net?
List the asp.net validation controls?
What is application and session in asp.net?