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

Mmm

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).