Default Oracle SQL code for CUD stored procedures

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
JoergB
Posts: 5
Joined: Tue 04 Aug 2015 08:48

Default Oracle SQL code for CUD stored procedures

Post by JoergB » Tue 04 Aug 2015 09:05

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Default Oracle SQL code for CUD stored procedures

Post by Shalex » Tue 04 Aug 2015 13:40

JoergB wrote: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.

Post Reply