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 are the Types of state management techniques
What is server side in asp.net?
Which property is used to identify the Page is Post Back in ASP.NET?
What is state management technique?
Describe session handling in a webfarm, how does it work and what are the limits?
Is it possible for me to change my aspx file extension to some other name?
What is jade template engine?
Why do we use datasource in asp.net?
Is asp.net core faster?
Explain diff. Betn dataset and recordset?
can we remote debug applications with the remote debugger installed with vs.net 2002, with vs.net 2003?
How can I create master page in asp net?
Which browsers support the xmlhttprequest object?
Explain repository pattern in asp.net mvc? : asp.net mvc
What is the use of session?