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 postback and autopostback in asp.net?
What is the difference between response.redirect and server.transfer?
What is meant by ispostback in asp net?
Explain how do you validate the controls in an asp .net page?
What is the mvc model?
What is the behavior of a Web browser when it receives an invalid element?
Can you clarified A Web service can only be written in .NET or not?
How many web config files can be created for an application?
What is the purpose of master page?
What is the use of data set in asp.net?
How many types of Cookies are available in ASP.NET?
Using code explain Configuration Management
What is mvc in asp.net tutorial? : Asp.Net MVC
What is sdlc process?
Can a .net web application consume java web service?