I have noticed different behaviour between Direct=True vs Direct=False.
I insert a MyTable entity with Timestamp set as follows, my timezone is GMT+1:
Code: Select all
myTable.Timestamp = DateTime.Now;
- Direct=true (Direct mode): 05.01.11 13:19:40,732423 +00:00
Direct=false (Oracle client mode): 05.01.11 13:19:49,663316 +01:00
In Direct mode, shouldn't the DateTime assumed to be local time, like how the Oracle client handles it, or is this expected behaviour?
This causes problems for us because the data in the TIMESTAMP WITH TIMEZONE columns are different depending on whether Direct mode is true or false. The data should be the same no matter what mode I am using.
I am using Devart dotConnect for Oracle Professional 220.127.116.11.