Interested to Buy Any Domain ? << Click Here >> for more details...
which one is faster execute reader, scalar, execute non
query ?
- 18 Answers
- 35849 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
Why do we need Sessions?
What are the versions of garbage collection?
What is simple data binding?
What is _viewstart?
How many types of cookies are available in asp?
Explain serialization and deserialization?
How to implement role based security in asp.net mvc? : Asp.Net MVC
How to prevent client side validation from the ASP.NET validation controls?
What are the asp.net 2.0 features?
How many languages are supported by .NET at present time?
What are the advantages of Web API?
Define xmlreader class.
What are the benefits of view state?
What is the difference between pathparam and queryparam?
What are the steps to follow to host a web application on a web server?
