StoreGeneratedPattern="Computed" column is not updated

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Olivier Van Hege
Posts: 1
Joined: Tue 17 Aug 2010 10:09
Location: Belgium

StoreGeneratedPattern="Computed" column is not updated

Post by Olivier Van Hege » 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.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 17 Aug 2010 13:27

We have sent you a test project.

sajmiraz
Posts: 1
Joined: Tue 23 Nov 2010 09:45

Same problem here

Post by sajmiraz » Tue 23 Nov 2010 09:51

Hi,

I am also experiencing this problem and I hope you can also send me a sample project for this. Thanks.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 23 Nov 2010 12:02

We have sent the test project to the e-mail address provided in your forum profile.

Post Reply