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

[Hans]

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.

[PetarP]

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.

Regards,
Petar
the Telerik team