StoreGeneratedPattern = Identity being reset
Posted: Thu 13 Mar 2014 17:29
I understand that I have to manually set StoreGeneratedPattern = Identity for my identity columns based on the following from documentation :
"the users have to set the value of StoreGeneratedPattern manually in the model editor."
How do you keep this from being reset when updating the model from the database ?
1. Create a model from database
2. Set StoreGeneratedPattern = Identity for my primary key (backed by trigger / sequence)
3. All is good.
4. Run update model from database.
5. Changes are detected
6. Accept changes.
7. The previously set StoreGeneratedPattern = Identity is reset
"the users have to set the value of StoreGeneratedPattern manually in the model editor."
How do you keep this from being reset when updating the model from the database ?
1. Create a model from database
2. Set StoreGeneratedPattern = Identity for my primary key (backed by trigger / sequence)
3. All is good.
4. Run update model from database.
5. Changes are detected
6. Accept changes.
7. The previously set StoreGeneratedPattern = Identity is reset