Default Oracle SQL code for CUD stored procedures

[JoergB]

Question concerning dotConnect for Oracle and EF6:

I would like to modify the default cud stored procedures in order to suit my needs, and use the altered ones instead of the default ones. But first I need to know how they should look like. Especially if the first column is an auto-generated primary key. And which order the parameters should be in.

How can I generate the PL/SQL code for the default stored procedures for INSERT, UPDATE, DELETE functionality?

Thank you!

Joerg

[Shalex]

How can I generate the PL/SQL code for the default stored procedures for INSERT, UPDATE, DELETE functionality?

You should create the corresponding stored procedures in the database manually like it is described at https://www.devart.com/dotconnect/oracl ... ngCUD.html (the definition of the DEPT_INSERT stored procedure assumes that there is a BEFORE INSERT trigger in the database which inserts sequence.NEXTVAL in DEPTNO of the new record).

If you have any further questions, please specify the name of the predefined template (e.g.: DbContext) you are using and its non default settings.