Is there a way to set config.DatabaseScript.Column.NumericIdentityBehavior when using EF with dotConnect for DB2? I've seen it implemented in dotConnect for Oracle but I can't find it here.
Regards,
Andrej
NumericIdentityBehavior for DB2
Re: NumericIdentityBehavior for DB2
Currenly this option is not implemented in dotConnect for DB2.
Could you please tell us how you want to change a default behavior with config.DatabaseScript.Column.NumericIdentityBehavior?
Could you please tell us how you want to change a default behavior with config.DatabaseScript.Column.NumericIdentityBehavior?
Re: NumericIdentityBehavior for DB2
I would like it to be GENERATED BY DEFAULT instead of GENERATED ALWAYS.
I think this would be the same as setting the Oracle config like so:
Edit:
The generated code first migration script now looks like this:
The end result I hope to achieve is this:
I think this would be the same as setting the Oracle config like so:
Code: Select all
config.DatabaseScript.Column.NumericIdentityBehavior = NumericIdentityBehavior.GeneratedByDefaultAsIdentity;
The generated code first migration script now looks like this:
Code: Select all
CREATE TABLE Account (
Id INTEGER GENERATED ALWAYS AS IDENTITY NOT NULL)
Code: Select all
CREATE TABLE Account (
Id INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL)
Re: NumericIdentityBehavior for DB2
Thank you for the details. We will notify you when the option config.DatabaseScript.Column.NumericIdentityBehavior is implemented.
Re: NumericIdentityBehavior for DB2
The new config.DatabaseScript.Column.NumericIdentityBehavior configuration option is implemented to manage a generation of columns with StoreGeneratedPattern="Identity": viewtopic.php?f=52&t=35925.