Oracle sequence not retrieved

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
sysman
Posts: 6
Joined: Fri 13 Oct 2017 19:33

Oracle sequence not retrieved

Post by sysman » Sun 05 Nov 2017 21:18

Hi
I have a table with sequence as primary key ID in oracle database.
I want to retrieve nextval generated sequence in method of class after insert new record.
I set "Store Generated Pattern" attribute to "Identity" for pk column in model.

I read this viewtopic.php?t=16882topic but can't help me.

Entity Developer version is 6.1.33

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Oracle sequence not retrieved

Post by Shalex » Tue 07 Nov 2017 18:06

Please make sure that you set StoreGeneratedPattern=Identity in the SSDL (!) part of your model: navigate to Model Explorer, expand the *.Store node, select the corresponding column, press F4 (Properties) and set StoreGeneratedPattern attribute=Identity.

If this doesn't help, upload a small test project with DDL/DML script to ftp://ftp.devart.com (credentials: anonymous / yourEmail).

Post Reply