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

Categories >> Software >> Microsoft Related >> ASP.NET
Suggest New Category

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

Question Posted / manoj dagar

18 Answers
35344 Views
Intiger, Minecode, I also Faced
E-Mail Answers

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

How do you add a javascript function for a link button in a datagrid ?

4 Answers Microsoft,

what is diff between responseexpires and expiresabsolute

2 Answers Accenture,

Define the term Web Garden?

0 Answers Sans Pareil IT Services,

The question is "After sign out from email, Then we click a back button , we can't go to the previous page ie inbox page, It is displaying a login form only" My doubt is How will code this , If u know please blog me through this or my mail. my mail id is yoursguna@gmail.com

3 Answers TCS,

In which scenario we use Session and Cookies? With Example..

1 Answers

How you can manage the state of application at the server side in ASP.NET?

0 Answers

How many modelpopup extender we frequire when we want more than one model popup on same page ?

3 Answers TCS,

Explain Apache web servers ? How can you get ASP.NET running in Apache web servers - why should you do this?

0 Answers Siebel,

How to count the number of objects present in a web page? How to count the number of radio buttons in a web page?

0 Answers HCL,

Does google crawl redirects?

0 Answers

What layout mode is the default when a new Web Form is created? a) GridBagLayout b) GridLayout c) FlowLayout d) FormLayout

2 Answers Syntax Softtech,

What is difference between Fragment Caching and Page Caching in ASP.NET?

0 Answers PUCIT,

For more ASP.NET Interview Questions Click Here