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
How to comment out asp.net tags?
Where session variables are stored?
What is the difference between an htmlinputcheckbox control and an htmlinputradiobutton control?
What is viewstate? What does the “enableviewstate” property do?
What is asp.net mvc5? : Asp.Net MVC
What's the ASP.Net Application life cycle?
Where are session variables stored?
Explain Optimization technique description?
Can a .net web application consume java web service?
About CLR, reflection and assemblies?
How u refer webservices?
Can more than one person use the same login?
What are different types of authentication techniques that are used in connection strings to connect .net applications with microsoft sql server?
What is the difference between user control and custom control?
Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?