Bind Datasource to Persistent Class Queried by Stored Proc

Thread is closed for posting
2 posts, 0 answers
  1. James Harkins
    James Harkins avatar
    11 posts
    Member since:
    Dec 2009

    Posted 27 Jun 2010 Link to this post

    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

  2. Serge
    Admin
    Serge avatar
    375 posts

    Posted 29 Jun 2010 Link to this post

    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
Back to Top