Devart Forums

Hello all,

I am trying to create an application that will support SQL Server and Oracle as a backend database using the Entity Framework. Have you guys found a way to support the auto increment feature for Oracle in the Entity Framework? I know SQL Server uses the autoincrement field and Oracle uses sequences which doesn't make the answer to keep the codebase between the two very simple.

Marc

You should write a couple of triggers (on update and on insert) setting the value of the autoincrement column.
Then create the model and add StoreGeneratedPattern = "Identity" to the SSDL column definition.

AndreyR wrote:You should write a couple of triggers (on update and on insert) setting the value of the autoincrement column.
Then create the model and add StoreGeneratedPattern = "Identity" to the SSDL column definition.

Beautiful thanks!