which one is faster execute reader, scalar, execute non
query ?

Answer Posted / d k

Wrong Question , As ExceuteReader(),ExecuteNonQuery() and
ExecuteScaler() interact to database in same manner and we
all Know about the ExceuteReader(),ExecuteNonQuery() and
ExecuteScaler() serves for different purpose , as
ExceuteReader() reads data against select query ,
ExecuteScaler() reads single cell value and
ExecuteNonQuery() used for action query not returns any
result set.

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the two types of web pages?

516


Briefly describe the role of global.asax?

576


What is the recommended approach for asp.net mvc to globally intercept exceptions? What other functionality can be implemented with the approach? : Asp.Net MVC

492


How do I use a proxy server when invoking a web service?

525


benefits of migration from asp to asp.net hi frnds, i have to give presentation to a client about how useful would be migrating their project from asp to asp.net .plz give me some points which i should incorporate in my ppt thanks

1762






what is command line compiler.what are the steps and how it is related to debugging.

1409


Define cookie.

564


How many types of validators are there in asp net?

490


What is server transfer?

493


What is server side session management?

524


How do you sign out from forms authentication?

553


How to make sure that contents of an updatepanel update only when a partial postback takes place (and not on a full postback)?

521


Explain what are the advantages of asp.net mvc framework? : asp.net mvc

515


Define satellite assemblies.

584


What is difference between viewstate and session in asp net?

559