Oracle TimeStamp

Topics: Data Access Application Block
Nov 3, 2008 at 7:54 PM

We are using the Oracle TimeStamp to manage concurrency in our application. Is there any support for the Oracle TimeStamp in the EntLibs? As far as I can see there is not. The best you can do is convert it to a dateTime however with that approcah you lose precision.

Nov 4, 2008 at 3:30 AM
Edited Nov 4, 2008 at 3:32 AM

There is support for Oracle Timestamp data type.  Use an OracleDatabase instead of the generic Database class.  




OracleDatabase db = DatabaseFactory.CreateDatabase() as OracleDatabase;




OracleCommand command = new OracleCommand("sp_AddCustomer");




"param1", OracleType.Timestamp, 5, System.Data.ParameterDirection.Input, true, 1, 1, "Name", System.Data.DataRowVersion.Current, string.Empty);


Sarah Urmeneta
Global Technology and Solutions
Avanade, Inc.