Stored Procedure with OpenAccess ORM

[Vipin]

I have requirement. I have a stored procedure which returns a result set.The result set is dynamic. So I am unable to create a specific model for the result. I have to generate an Excel from the application based on the Result. I need to call the SP from EntityModel, but can't use a specific model to retrieve data. Right now I am using this code:

using (EntitiesModel1 ctx = new EntitiesModel1())
{
Telerik.OpenAccess.SqlParameter pOrderDetailID = new Telerik.OpenAccess.SqlParameter("OrderDetailID", OpenAccessType.Int32);

List<Telerik.OpenAccess.SqlParameter> sqlParameters = new List<Telerik.OpenAccess.SqlParameter>()
      {
        pOrderDetailID
};

object queryResult = ctx.ExecuteStoredProcedure<object>("[sp_OrderDetailView]", sqlParameters, orderDetailID);
return queryResult;
}

But this code basically returns an Object Array, from which I am unable to read the Field/Column name. 
Is there a method using which I can get a DataSet which I can easily parse and generate the Excel?

[Damyan Bogoev]

Hello Vipin,

I am afraid you cannot achieve this goal out-of-the-box. You could use the OpenAccessContext.ExecuteQuery<TResult>(...) in this scenario with object, persistent type or a complex type as a generic argument. This means you have to be aware of the result shape at the moment you are using the Context API method. 

You need to combine the ExecuteQuery method with some additional logic, which accounts for the result shape returned, to be able to consume the stored procedure result correctly.

Hope that helps.

Regards,
Damyan Bogoev
Telerik