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

Bind Datasource to Persistent Class Queried by Stored Proc

1 Answer 47 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.
James Harkins
Top achievements
Rank 1
James Harkins asked on 28 Jun 2010, 03:46 AM
I have spent several hours looking for a solution and found nothing.

I need to bind a OpenAccess DataSource to a persistent class and have the class query be populated via a stored proc.

The stored procedure has one parameter an int ID that has to be passed in.

Any ideas...

Thanks

1 Answer, 1 is accepted

Sort by
0
Serge
Telerik team
answered on 29 Jun 2010, 07:00 PM
Hi James Harkins,

 Unfortunately the OpenAccessDataSource does not support querying the database directly. There is no way to use a stored procedure to get values for the data source. You can either use default behavior and let the data source query the database or use the Command Text property of the data source to specify the OQL query used to retrieve the result set.

You can find more information on the command text property in this help article. While this might not be the solution you are looking for, the OQL query that you can build can be quite complex and replace the stored procedure. You can find more information on OQL here.

I do hope this helps.

Kind regards,
Serge
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
James Harkins
Top achievements
Rank 1
Answers by
Serge
Telerik team
Share this question
or