Scalar vs Reader Exec Method

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

Is there any advantage of using scalar execution method for data adapter if
the result is going to be a single record?

Thanks

Regards
 
Scalar only gives you back the first field from the first record, so if you
want the whole record, don't use scalar.

Scalar is generally good for when you are calling a user function in the DB
to get back a single result.

-Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calling/using a sql server scalar valued function 0
Using ExecuteScalar on ,Net Framework 1.1 4
calling sql server 2005 function in access 1
Retrieving a single value from a dataset 1
Working with multiple typed datasets under same transaction 2
How to create trivial CRUD app using data binding and Entity Framework? 0
Cannot return recordset when I'm using parameters? 1
Must declare the scalar variable "@CheckUser" 1

Back
Top