Interested to Buy Any Domain ? << Click Here >> for more details...
which one is faster execute reader, scalar, execute non
query ?
- 18 Answers
- 35818 Views
- Intiger, Minecode, I also Faced
- E-Mail Answers
Answer Posted / vikas kant
1.Execute scalar is most fastest bcoz it returns only
single value.
2.Afterwards Execute reader bcos it reads data in forward
only or read only mode as well as has the live connection
with the database.
3.At last Execute Non Query bcoz it makes the changes in
database.
Execute Scalar ---> Execute Reader ----> Execute Non Query.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Disable browser cache for entire ASP.NET website?
Why Unload event of MasterPage Calls first in ASP.net ?
What are session objects?
What is virtual directory in asp.net?
In order to bind the data from a data source to the Repeater control what property is set and what method must you call in your code,?
Explain the reason why the javascript validation not run on the asp.net button but run successfully on the html button?
What is difference between inproc and outproc?
What are strong names?
a)COM Callable Wrapper b)Runtime Callable Which one of the above is Win32 API in .Net?
What is asp.net globalization?
What is the difference between mvc and asp.net? : Asp.Net MVC
Where the viewstate is stored after the page postback?
What is the difference between debug and release?
Is post back property in asp net?
Explain the difference between value type and reference type?
