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 symbol would you use to denote, the start of a code block in aspx views?

741


Contrast oop and soa. What are tenets of each16. How does the xmlserializer work? What acl permissions does a process using it require?

717


Which protocol is used to call a web service?

764


Is post back property in asp net?

732


What is request and response in asp.net?

711


Tell me how asp.net mvc differs from asp.net web forms? : asp.net mvc

794


How do I publish my asp.net application to my isp's web server?

785


How is session id generated?

645


What are validator? Name the validation controls in asp.net? How do you disable them? Will the asp.net validators run in server side or client side? How do you do client-side validation in .net? How to disable validator control by client side javascript?

746


Explain how asp.net different from asp?

785


calling result set one procedure to anothar procedure in sql2000

1518


What is inproc and outproc?

733


Explain how can we inherit a static variable?

750


Explain server-side scripting and client-side scripting.

686


Where is asp.net view state stored?

728