return storedprocedure result in a typed list

Posts   
 
    
riclo
User
Posts: 7
Joined: 13-Aug-2010
# Posted on: 22-Oct-2010 14:23:10   

Hello,

I want to add the result of a stored procedure (actually an ActionProcedure which returns an integer) in my dynamic typedlist.

For an aggregate function you would use :

entFields.Expand(1); entFields.DefineField(new EntityField2("NumberOfOrders", new ScalarQueryExpression(CustomerFields.CustomerId.SetAggregateFunction(AggregateFunction.Count), (CustomerFields.CustomerId == OrderFields.CustomerId))), 0);

How can I do this for an ActionProcedure?

Richard

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 23-Oct-2010 06:32:11   

Mmm disappointed

How would look like your SQL if you have to write it by hand? Could you wrap the SP in a function call? (that way I think you could use DBFunctionCall as an expression in the expanded field).

David Elizondo | LLBLGen Support Team