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:
(EntitiesModel1 ctx =
Telerik.OpenAccess.SqlParameter pOrderDetailID =
List<Telerik.OpenAccess.SqlParameter> sqlParameters =
queryResult = ctx.ExecuteStoredProcedure<
, sqlParameters, orderDetailID);
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?