Thank you for your interest in Telerik OpenAccess ORM.
Currently, the ability to execute stored procedures and functions through OpenAccess ORM is improved for both domain models (created and maintained through Visual Designer
) and fluent models (utilizing the Code - Only Mapping
approach). At the time present it is possible to map a stored procedure or a function to a method of the context and to call it through it. The call itself utilizes our Low Level (ADO) API
, and in order to assist you in generating the method (for domain models only) we introduced Domain Method Editor
Basically, Domain Method Editor
generates the domain method for you in the context class, and creates the appropriate result shape (if such is necessary). You can find more details, code samples, and fundamental workflows in this section
of your documentation.
In case you decide to use a fluent model and need to create methods mapped to stored procedures / functions manually, the relevant information is available in this section
Regarding the consumption of the generated methods with Kendo UI as user interface layer, please kindly find attached to this message a sample project that uses OpenAccess ORM in the data access layer, and a Web API service generated with our Add OpenAccess Service wizard that exposes the stored procedure. The sample utilizes our SofiaCarRental
database and requires the following steps in order to run it:
1. Unrar the attached file.
2. Execute the script for the SofiaCarRental database on your local server instance.
3. Apply the necessary settings for the connection string in the web.config file.
4. Upgrade the OpenAccess references as described in this documentation article
5. Build the solution and run the sample.
I hope you find this feasible. If you have additional questions, or experience difficulties, do not hesitate to get back to us.
OpenAccess ORM Q3 2013 simplifies your model operations even further providing you with greater flexibility. Check out the list of new features
shipped with our latest release!