Oracle TimeStamp

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

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.

Thanks,
BretteNet
Nov 4, 2008 at 2:30 AM
Edited Nov 4, 2008 at 2: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");

 

db.AddParameter(command,

 

"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.
sarah.b.urmeneta@avanade.com