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 disadvantages of view state?

600


How can we access static variable?

651


Define repository pattern in mvc.net? : asp.net mvc

518


To display data in a Repeater control which template you provide?

595


What are url fragments?

508






Explain the difference between response.redirect vs server.transfer

620


What do you mean by serialize and marshalbyref?

573


How can we apply themes to an asp.net application?

562


How will create assesblies at run time?

556


What is session mode in asp.net?

523


Will session work if cookies is disabled?

530


What is difference between View State and Hidden Field in ASP.NET?

663


calling result set one procedure to anothar procedure in sql2000

1342


Which class is used to send an email message from an ASP.NET Web page?

548


Which Is Faster MVC or ASP.net ?

588