How to use additional input parameter in Stored Procedures for CUD actions

2 posts, 0 answers
  1. Hans
    Hans avatar
    7 posts
    Member since:
    Sep 2012

    Posted 24 Sep 2012 Link to this post

    I am a new OpenAccess user and I have an issue I could not find in your online documentation.

    For our business Entity model we want to use Stored procedures for the CUD actions to map the business model to our database model with OpenAccess (database is SQL Anywhere). The Retrieve action from the database are mapped by a database View to hide the database model.

    We have identified some business rules that should reject some user roles having write access to our database. If we put that business rule in the Stored Procedure we can have less C# code and better performance due to the Stored Procedure. The database contains the user, roles etc. tables and is able to handle this business functionality in the Stored Procedures.
    In that case we need for the Stored Procedure an -additional- free defined parameter with our user ID to do so.

    1. Is it possible to add additional (a user ID) parameters as an input for our Stored Procedures in OpenAccess?
    2. How can we do that?
    3. How can we pass the additional parameter user ID value to the Stored Procedure with OpenAccess?

    Thanks in advance.

  2. PetarP
    PetarP avatar
    754 posts

    Posted 25 Sep 2012 Link to this post

    Hi Hans,

     I suggest we keep the conversation in just one of your threads as it will be much easier to track the progress there. Please find my answer in this thread.

    the Telerik team
    Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
  3. DevCraft banner
Back to Top