Insert Errors using Triggers to load Identity

[jkuhn]

Our DBA uses insert triggers to set all table identity fields which are defined as NUMBER(9) NOT NULL. The Modeller defines as int32 and tries to insert will a zero causing and duplicate primary key db exception. For identity fields can I tell the framework not to supply a value but fetch the the new ID value after the insert. There are also several other fields not supplied with values requiring synchronization after insert or update (last update, version ect.) how is this done?

[Shalex]

When creating a model in Schema Modeler, try setting the following properties for the ID column:
1. Auto Generated Value to True
2. Auto-Sync to Always
Other columns, whose values are generated in database, should have the same properties set.