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
If you are using components in your application, how can you handle exceptions raised in a component?
How information about the user's locale can be accessed?
Distinguish between Server-side and Client-side code with its functionality?
Why viewstate is used in asp.net?
Explain the concept of event bubbling in ASP.NET?
Why do we use asp.net?
Take a Large textbox allow to type any data. Task 1:display the count of vowels in a lable on key press event of the textbox Task 2:dispaly count of dates in a lable when dates in following foramats:dd/mm/yy , mm/dd/yy , yy/mm/dd. Task3:compare 2 dates and display both are same or not which dates are in dd/mm/yy and mm/dd/yy farmats.
What is the advantage of using Windows authentication in a Web application?
What is difference between inproc and outproc?
How to retrieve user name in case of Window Authentication?
What is role-based security in asp.net?
Where the cookie value is stored?
What is variable and constant in .net programming language?
What is State Management in .Net and how many ways are there to maintain a state in .Net? What is view state?
How many types of sessions are there in asp net?