which one is faster execute reader, scalar, execute non
query ?
Answer Posted / anirudh g
Scalar will be faster that the execute reader and execute
non query. As scalar only fetch one column single row.
Whereas execute reader may return numbers of record and
though non-query will not return any records it will take
time to identify the data types to validate be4 inserting
the data
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain serialization and deserialization?
Explain model, view and controller represent in an mvc application? : asp.net mvc
What is the difference between CC and BCC?
What is the purpose of App_Code folder in ASP.NET? Why we this?
What is the difference between session and viewstate in asp.net?
What are the properties of the eventargs argument when capturing keyboard events?
Difference between Response.redirect vs server.transfer?
if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....
What is the compiled object?
Describe Segmentation With Paging?
Explain in what order a destructors is called.
What is xaml? Are xaml file compiled or built on runtime?
What is the difference between exe and dll?
What is anonymous authentication?
What are the differences between the response.write() and response.output.write()?