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 about the .NET framework?

829


Can you explain architecture of your project ?

867


Give an example of cookie abuse.

832


What is the biggest disadvantage of “Other Return Types” in Web API?

1161


What is redirectpermanent in asp.net?

822


What are the differences between clr & cts?

747


What is comparevalidator?

721


What is asp.net and how it works?

722


Which is the best institute to learn Microsoft Technologies and the faculty if you Know?

1830


What are the difference between overriding and overloading?

710


What is paging in context of Memory?

876


What is data grid view in asp.net?

707


What is difference in .net 1.1 and .net 2.0?

792


How should I destroy my objects in asp.net?

801


Explain what are the advantages of asp.net mvc framework? : asp.net mvc

756