Page 1 of 1

Oracle sequence not retrieved

Posted: Sun 05 Nov 2017 21:18
by sysman
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

Re: Oracle sequence not retrieved

Posted: Tue 07 Nov 2017 18:06
by Shalex
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).