CapableObjects Knowledgebase

Home Search Tags Glossary Members

Welcome Guest ( Login | Register )

Home » Knowledgebase » Enterprise Core Objects » Persistence » How to set up Autoinc keys with ECO

How to set up Autoinc keys with ECO

How to set up Autoinc keys with ECO

When storing objects in a database ECO will allocate unique IDs to each object. The default mechanism will allocated the IDs using a table called ECO_ID (surprise surprise). If you want to change to database generated IDs (AutoInc), follow these steps:

Open your PersistenceMapperProvider designer
Add a DefaultORMappingBuilder component on the designer
Rightclick it and select "Setup AutoIncKeys"
Select your PersistenceMapperXXX and set "RuntimeMappingProvider" and "NewMappingProvider" to the new component (defaultORMappingBuilder1)

This change is not supported by DbEvolve, so you will need to regenerate the database schema after this change. Any new table added by evolve after this change will have the correct column type, but old tables will not be updated.