Page 1 of 1
How to convert sql server timestamp to oracle
Posted: Fri 02 Apr 2010 05:00
by James_phe
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
Posted: Fri 02 Apr 2010 12:14
by AndreyR
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.
Using Numberic Value instead of TimeStamp
Posted: Wed 22 Sep 2010 17:23
by AKhan
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?
Posted: Thu 23 Sep 2010 08:12
by StanislavK