How to convert sql server timestamp to oracle

How to convert sql server timestamp to oracle

Postby 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
James_phe
 
Posts: 1
Joined: Fri 02 Apr 2010 04:44

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Using Numberic Value instead of TimeStamp

Postby 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?
AKhan
 
Posts: 4
Joined: Wed 22 Sep 2010 17:17

Postby StanislavK » Thu 23 Sep 2010 08:12

We've answered you in this topic:
http://www.devart.com/forums/viewtopic.php?t=19055
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle