This is a migrated thread and some comments may be shown as answers.

Can a manually-defined persistent class be used as the return type of a stored procedure?

3 Answers 98 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Chris Jansen
Top achievements
Rank 1
Chris Jansen asked on 19 Sep 2009, 04:06 PM

Hi,

I have a few stored procedures whose results do not map to a table in the database. In situations like this, it looks like the options are to retrieve the data from an object array that is returned, or create an empty view on the database and use it as the return type.

Is it possible to manually create a persistent class in the data model that does not exist in the database, and can be used as the return type for a stored proc?

Thanks.
Chris

3 Answers, 1 is accepted

Sort by
0
Zoran
Telerik team
answered on 23 Sep 2009, 06:14 AM
Hi Chris Jansen,

This question has been answered in the support thread you have started on this topic.

Kind regards,
Zoran
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Zsolt
Top achievements
Rank 1
answered on 11 Feb 2010, 11:07 AM
I have a same issue with mapping stored procedure result to entites. Is the answer avialable to Chris' question?
0
Zoran
Telerik team
answered on 16 Feb 2010, 10:39 AM
Hi Zsolt,

Defining a custom persistent class to preserve the results of a stored procedure is not currently supported by OpenAccess. You can define your class(non persistent) and have your own materialization logic as a workaround. I think that the easiest way to automate the workflow with OpenAccess would be to create database view that resembles the returned values by the stored procedure and then use that view as the return type of the stored procedure.

Best wishes,
Zoran
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
General Discussions
Asked by
Chris Jansen
Top achievements
Rank 1
Answers by
Zoran
Telerik team
Zsolt
Top achievements
Rank 1
Share this question
or