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

Answers were Sorted based on User's Feedback



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

Answer / ashish

execute reader

Is This Answer Correct ?    39 Yes 7 No

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

Answer / amit

Scalar Bcoz it return's only 1 result that's why scalar.

Is This Answer Correct ?    29 Yes 3 No

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

Answer / 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

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

Answer / kalirajan

Reader... Bcoz It read the data directly from the database

Is This Answer Correct ?    12 Yes 4 No

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

Answer / abhishek

Execute scalar is faster so it is execute one row at the
time

Is This Answer Correct ?    9 Yes 1 No

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

Answer / santhosh

execute reader is fast

Is This Answer Correct ?    7 Yes 0 No

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

Answer / akhilesh

Execute Scalar

Is This Answer Correct ?    8 Yes 2 No

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

Answer / ananth

Excute reader is to easy and quickly fetch the data from
database. but in some casse excute non query is more useful
than excute query , excute reader and excute scalar


thanks

Is This Answer Correct ?    5 Yes 0 No

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

Answer / 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

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

Answer / monalika

Execute Reader is faster it
internally stores result of a query as an array.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

What are the validation controls available in ASP.NET?

0 Answers  


What are the different kinds of assemblies?

0 Answers  


Hi! Could any 1 please suggest me a free practice online exam for asp.net exams.. thanks

1 Answers  


What is the current version of asp.net?

0 Answers  


How to execute a stored procedure.and how to call it form a asp page

2 Answers  


Explain some of the major built-in objects in asp.net

0 Answers  


How does session state work in asp.net?

0 Answers  


Can you dynamically assign a Master Page?

0 Answers   MCN Solutions,


What is sta?

0 Answers  


How to consume a webservice in a windows application without adding through the web reference?

1 Answers   247Customer,


what is the dllhell? why we use the dllhell?

4 Answers  


can any one find and tell the difference between dot net and php which one is best ? which one we get more salary? which one is stable and which one is best for freshers and also better in future and carrer ? which one we wil get more salary sir ? please send ur valuable suggestions to kiranpulsar2007@gmail.com

0 Answers  


Categories