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
Is it possible to migrate visual interdev design-time controls to asp.net?
Differences between “dataset” and “datareader”.
How asp.net mvc differs from asp.net web forms? : asp.net mvc
How to automatically get the latest version of all the asp.net solution items from source safe when opening the solution?
How can you implement the postback property of an asp.net control?
Explain asp.net web forms.
What are the major built-in objects in ASP.NET?
In a webservice, need to display 10 rows from a table. Which is the best choice among datareader or dataset?
Can you explain why it is useful to use mvc instead of webforms? : asp.net mvc
What are different methods of session maintenance in asp.net?
What tags do you need to add within the asp:datagrid tags to bind columns manually? How?
How many types of validation are there?
What is view state and how it works in asp net?
What is session and application variable in asp net?
What are the disadvantages of asp.net?