Indeed, the approach you describe for the execution of the stored procedure is in the correct direction, and Domain Method Editor does not support code generation for system stored procedures.
You can complete the necessary task and retrieve the result from the procedure with the help of our Low Level ADO API
. It basically offers a wide variety of means that allow you to execute SQL statements through ADO like code. One of them allows you to translate DbDataReader
objects to non-persistent types. The details about the workflow are described in this documentation article
Additionally, kindly find attached a sample console application that implements the workflow. In order to run it, I would suggest to you the following workflow:
1. Unrar the attached file.
2. Apply the necessary settings for the connection string in the app.config file.
3 Upgrade the OpenAccess references as described in this documentation article
4. Build the solution and run the sample.
Note that the sample utilizes Visual Studio 2013. If you experience difficulties opening it, let us know.
I hope you find this feasible. If you need additional information or further assistance, 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!