Primary key on Oracle

[stos....@gmail.com]

Hi

When I use a primary key (ID) like :

.WithColumn("Id").AsInt32().NotNullable().PrimaryKey().Identity();

I get an error from oracle:

!!! Oracle does not support identity columns. Please use a SEQUENCE instead
!!! FluentMigrator.Exceptions.DatabaseOperationNotSupportedException: Oracle doe
s not support identity columns. Please use a SEQUENCE instead

How to deal with it?

[Tom Marien]

Hi

Atm the current processor for oracle does not support identity's yet, from oracle 12c this should be possible.

You should use a sequence with a trigger see http://stackoverflow.com/questions/11296361/how-to-create-id-with-auto-increment-on-oracle for more info

KR 

[stos....@gmail.com]

Hi

I can see that Oracle supports identities now, but Fluent Migrator still doesn't. Any solutions?