Hi Henrik, Sebastien
Actually there is a way to set up the classes to use the HighLow key generator and you can easily do so by selecting a class in the diagram, pressing F4 which will open up the property pane and in the Identity Mechanism select HighLow
However with Oracle this might not be the best idea, if you have database objects, with defined sequences and triggers over the identities you can set up OpenAccess
in such a way that this is respected and identities are automatically retrieved, which I think is what you are trying to achieve.
When you are using MS SQL and you reverse map an auto-incremental column you get a property that is populated after the SaveChanges()
call. In Oracle however as this is done with sequences and triggers our schema read cannot (at the moment) read this information. This means that you will have to explicitly set this up. What you need to do is locate the desired class again press F4 and in the same property select BackendCalculated
as the value. Make sure that the property that is mapped to your auto incremental column is set up as a primary key. Then go to the Schema Explorer
and locate the table this class is mapped to, right click and select Edit Table,
then find the column you want calculated and set it up as a Backend Calculated column.
After you have completed these steps, whenever you insert a new object and persist the changes to the database you will get the identity property of your newly inserted object populated with the new value.
I hope this proves to be helpful to you.
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Public Issue Tracking
system and vote to affect the priority of the items