All types seem to work, but it doesn’t work correctly with type OracleDbType.TimeStamp.
I try to set the value from various method but every time the value in the Database is inserted to NULL and the DATEINSERT property is never NULL.
It’s possible to tell but what I’m doing wrong or there is an issue with TimeStamp type?
Code: Select all
ctx.Database.Connection.Open();
using (var copy = new OracleLoader("SYSTEM.ISSUE_406", (OracleConnection) ctx.Database.Connection))
{
copy.Columns.Add("ID", OracleDbType.Raw, 16);
copy.Columns.Add("COLUMNINT", OracleDbType.Number, 10, 0);
copy.Columns.Add("DATEINSERT", OracleDbType.TimeStamp, 7);
copy.Open();
for (int i = 0; i < 10; i++)
{
var entity = list[i];
copy.SetValue("ID", entity.ID.ToByteArray());
copy.SetValue("COLUMNINT", entity.COLUMNINT);
//copy.SetValue("DATEINSERT", entity.DATEINSERT.Value); // DO NOT WORK
//copy.SetValue("DATEINSERT", new OracleTimeStamp(entity.DATEINSERT.Value)); // DO NOT WORK
//copy.SetDate("DATEINSERT", entity.DATEINSERT.Value); // DO NOT WORK
//copy.SetTimeStamp("DATEINSERT", entity.DATEINSERT.Value); // DO NOT WORK
copy.SetTimeStamp("DATEINSERT", new OracleTimeStamp(entity.DATEINSERT.Value)); // DO NOT WORK
copy.NextRow();
}
}