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
What is a multilingual website?
How does u get record no from 5 to 15 from a dataset of 100 records?
Asp pages that worked pefectly on windows 2000 server and iis 5.0 do not work on windows 2003 server with iis 6.0. Asp.net pages work fine. Why?
What is difference between URL and URI?
Explain about the .NET framework?
What is a master page and what does it do?
Define tracing.
Can we have multiple master pages in asp net?
Which library is used by the testers and developers to develop automated tests and create testing tools?
Can you edit data in the Repeater control? Which template must you provide, in order to display data in a Repeater control? How can you provide an alternating color scheme in a Repeater control? What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?
what is loosely coupled solution? How it can be used?
What are assemblies and namespaces and explain the difference between them ?
Explain culture and uiculture values.
What is sta?
Is it true that a Web service must be written in .NET or not?