How to convert sql server timestamp to oracle

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
James_phe
Posts: 1
Joined: Fri 02 Apr 2010 04:44

How to convert sql server timestamp to oracle

Post by James_phe » Fri 02 Apr 2010 05:00

I have fininshed a project using Linq to sql.I use timeStamp column to implement optimistic concurrency control,It works great!Now,I want chang the database to oracle,the problem coming,I CAN NOT convert the timeStamp column to oracle directly.

Appreciate suggestions, many thanks in advance.

Regards,

James

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

Post by AndreyR » Fri 02 Apr 2010 12:14

I recommend you to create an update and insert triggers for Oracle timestamp column setting the value of the column to current_timestamp(). One more step is to set the IsVersion property to true for this column in Entity Developer.

AKhan
Posts: 4
Joined: Wed 22 Sep 2010 17:17

Using Numberic Value instead of TimeStamp

Post by AKhan » Wed 22 Sep 2010 17:23

Do we have to use TimeStamp for concurrency control. Can we just create a Numeric column and set it IsVersion = true. And if we do that will this auto increment the value on Update?

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Thu 23 Sep 2010 08:12

We've answered you in this topic:
http://www.devart.com/forums/viewtopic.php?t=19055

Post Reply