StoreGeneratedPattern="Computed" column is not updated
Posted: Tue 17 Aug 2010 11:35
Hello,
We are usign dotConnect for Oracle as our provider for Entity Framework to access an Oracle database.
We have designed our model from the database and in order to deal with concurency issues we are using a datetime column in the database on which a trigger is set so that the value is updated on each insert/update operation (not in code).
The column is marked as Concurency Mode = "Fixed" on our model so that Entity Framework can check for concurency issue and throw the exception if needed. This works fine.
As the value of this datetime column is set through a trigger inside the database, we have also set the StoreGeneratedPattern = "Computed" on our model, and have manually updated the SSDL section to include this as well (as stated in the following article http://blogs.u2u.be/diederik/post/2010/ ... rk-40.aspx).
But the problem is that the value never gets updated on our objects after calling SavingChanges on the context.
Also note that we are using Self-tracking entities.
Thank you in advance for your support as it is a crucial feature for us...
Olivier Van Hege (CTG) on behalf of WGK West-Vlaanderen.
We are usign dotConnect for Oracle as our provider for Entity Framework to access an Oracle database.
We have designed our model from the database and in order to deal with concurency issues we are using a datetime column in the database on which a trigger is set so that the value is updated on each insert/update operation (not in code).
The column is marked as Concurency Mode = "Fixed" on our model so that Entity Framework can check for concurency issue and throw the exception if needed. This works fine.
As the value of this datetime column is set through a trigger inside the database, we have also set the StoreGeneratedPattern = "Computed" on our model, and have manually updated the SSDL section to include this as well (as stated in the following article http://blogs.u2u.be/diederik/post/2010/ ... rk-40.aspx).
But the problem is that the value never gets updated on our objects after calling SavingChanges on the context.
Also note that we are using Self-tracking entities.
Thank you in advance for your support as it is a crucial feature for us...
Olivier Van Hege (CTG) on behalf of WGK West-Vlaanderen.