Is there any way to solve the .Net Entity Framework Oracle PL/SQL Sequence issue without trigger, while inserting data ? Interceptor should be a method for this but which way do you suggest? Thnx.
-
what "Oracle PL/SQL Sequence issue " are you talking about?Sathyajith Bhat– Sathyajith Bhat2015-01-16 10:59:37 +00:00Commented Jan 16, 2015 at 10:59
-
select nextval from sequence before inserting the entityeozcan– eozcan2015-01-16 12:05:37 +00:00Commented Jan 16, 2015 at 12:05
-
2Why the -1 vote? This is a very important question for Oracle users since it is the only database that 'requires' you to setup the auto-incrementing sequence for 'Identity' fields. I would like to see an Oracle DBA/programmer answer this question...FrankO– FrankO2015-02-11 03:43:22 +00:00Commented Feb 11, 2015 at 3:43
-
Oracle 12c supports auto incrementing sequences . Look at this answer stackoverflow.com/questions/11296361/…Ovidiu Buligan– Ovidiu Buligan2015-05-08 05:47:02 +00:00Commented May 8, 2015 at 5:47
-
Yep, Oracle 12c solves this problem but it seems using trigger is the single way to solve this problem on 11g. @Ovidiu if you can post your comment as a answer I will check solved this question, however it doesn't meet my expectations.eozcan– eozcan2015-05-11 13:38:36 +00:00Commented May 11, 2015 at 13:38
Add a comment
|
1 Answer
Oracle 12c adds support for autoincrementing sequences : How to create id with AUTO_INCREMENT on Oracle?
Until then there is not much to do but to use triggers . I have a sample project with ef 6 and oracle 11g only with nuget packages(works also in linux), check out my answer from this question:
