Telerik OpenAccess ORM - Executing an Oracle stored procedure that returns result sets

3 posts, 0 answers
  1. Telerik Admin
    Telerik Admin avatar
    1679 posts
    Member since:
    Oct 2004

    Posted 02 Aug 2011 Link to this post

    Requirements

    OpenAccess version 2011.2 713
    .NET version 4.0
    Visual Studio version 2010
    programming language C#

    PROJECT DESCRIPTION
    This project shows how to work with the Telerik OpenAccess ORM lower level ADO API and Oracle Stored Procedures, that have out parameters of type SYS_REFCURSOR. Two approaches are presented - using OpenAccessContext and using OACommand.
    The second one is more complex, but provides more control and flexibility. The HR sample database is used.

    PREREQUISITES
    • Make sure you have ODP.NET (ODAC) installed.
    • Make sure you reference the correct version of Oracle.DataAccess.dll in your project, it should be the same as the one defined in machine.config (4.0 by default)
    • Make sure you have a connection to a working Oracle database with the HR sample schema enabled. The HR schema is not active by default, it can be enabled from the Oracle admin webpage.
    • Run the script located next to the .sln file in the attached archive, named storedProcedures.sql . It will create the stored procedures needed for the demo.
  2. Henk
    Henk avatar
    113 posts
    Member since:
    Apr 2006

    Posted 04 May 2012 Link to this post

    Hi,

    Do you have also an example using the new wizard  (the sp  mapped as IEnumerable) and bind to a Silverlight grid(view) Also using  a domain dataservice like the introduction "getting started with orm and silverlight".

    Thanks,

    Henk
  3. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 09 May 2012 Link to this post

    Hi Henk,

    We do not have such example yet. We are planning to release a stored procedure usage sample with Q2 2012 release of the OpenAccess SDK, but the results are not shown in a Silverlight grid.

    What we do have now in the SDK is:
    - an example shows how Silverlight is working with OpenAccess exposing data through a RIA service
    - a WPF sample showing data exposed through a WCF Data Service.

    We hope that the current samples will be helpful for your scenario. In any case, do not hesitate to submit a support ticket if you need any assistance. 

    All the best,
    Ivailo
    the Telerik team
    Follow @OpenAccessORM Twitter channel to get first the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
Back to Top