which one is faster execute reader, scalar, execute non
query ?
- 18 Answers
- 32798 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
What are the server controls in asp.net?
How can I open ashx file in mobile?
Explain what is an assembly?
What does mvc represent in asp.net? : asp.net mvc
What is a 307 redirect?
What does passport and windows authentication mean in ASP.NET?
Explain exception handling in .net.
Define secured sockets layer.
What is routing in MVC?
Am not able to move the controls on the form freely in asp.net 3.5 even though I selected the position as relative or absolute for those controls. What should I do to overcome this?
Which data type does the rangevalidator control support?
What is asp net_sessionid?
Why do we use web config?
What is a form tag?
What are the advantages of asp.net?
