Interested to Buy Any Domain ? << Click Here >> for more details...
which one is faster execute reader, scalar, execute non
query ?
- 18 Answers
- 35182 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 is the use of dispose method?
How can we inherit a static variable?
What is a server farm in iis?
Explain the difference between asp.net mvc and asp.net webforms
What is the difference between mvc and asp.net? : Asp.Net MVC
What is AutoPostback?
How ASP and ASP.NET page works? Explain about asp.net page life cycle?
What is asp.net web application?
What is cookies in asp net?
What is asp.net mvc? : asp.net mvc
What is protected configuration?
How to do parallel database export in remote SQL Server in ESSL time track. It is working for local server but not working for remote SQL Server
Can we have a web application running without web.config file?
Error : The operation couldn’t be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction.00000110 oledb provider for linked server returned message the partner transaction manager has disabled its support for remote/network transactions. I can able to execute the stored procedure in sql server but when i run the web page getting error like above. I did all the configuration. what is the solution?
Difference between response.redirect and server.transfer?
