Execute Scalar like procedure

Posts   
 
    
amrosalah
User
Posts: 12
Joined: 04-Apr-2008
# Posted on: 02-Oct-2008 00:06:33   

Hello im using LLBL since coupla month , i notice that i can only have dataTable returning procedures or dataset , or action procedures . Can i have a procedure that returns a value same as ExecuteScalar ?

I hate the way iam doing it now dt.rows[0]["colname"] feel it could be cleaner .

thanks

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 02-Oct-2008 09:13:04   

The this is that by definition a Retrieval StoredProcedure always will return a DataTable. Options:

  1. Use output parameters.

  2. Wrap the call in a custom method that return the desire result.

David Elizondo | LLBLGen Support Team