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


Please Help Members By Posting Answers For Below Questions

Explain serialization and deserialization?

794


Explain model, view and controller represent in an mvc application? : asp.net mvc

731


What is the difference between CC and BCC?

827


What is the purpose of App_Code folder in ASP.NET? Why we this?

903


What is the difference between session and viewstate in asp.net?

885


What are the properties of the eventargs argument when capturing keyboard events?

852


Difference between Response.redirect vs server.transfer?

888


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....

1877


What is the compiled object?

1875


Describe Segmentation With Paging?

836


Explain in what order a destructors is called.

818


What is xaml? Are xaml file compiled or built on runtime?

752


What is the difference between exe and dll?

828


What is anonymous authentication?

824


What are the differences between the response.write() and response.output.write()?

771