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

What is cookieless session id explain in brief?

533


What are assemblies and namespaces and explain the difference between them ?

570


How does a content page differ from a master page?

510


What is query string in asp.net?

568


What is globalization and localization in asp net?

496






What is State Management in .Net and how many ways are there to maintain a state in .Net? What is view state?

586


What is autopost?

531


What is a runtime version?

535


How can we apply themes to an asp.net application?

562


What ports must be open for DCOM over a firewall? What is the purpose of Port 135?

1872


What is the meaning of TestApi?

637


What is the difference between c# and .net?

585


Is redux flux?

542


how to debug web services on consumer side?

582


Explain what is event bubbling?

578