title: "TIMESTAMP WITH TIME ZONE" <--> DateTImeOffset mapping won't deliver the Zone part on INSERT commands (Entity Framework + Oracle)
body: <p>I use EF (EDMX model - DB first) to map "TIMESTAMP WITH TIME ZONE" to a DateTimeOffset. when I commit the DateTimeOffset to Oracle, the Zone part is saved incorrectly.</p>
  
  <p>So if using the model, for example, to insert the value <code>29/02/2012 10:10:10 +04:00</code>, the value that is actually stored in Oracle is <code>29/02/2012 10:10:10 +02:00</code> (assuming +02:00 is local zone)
  Note that the mappings works just fine when querying the data. Only INSERT (via ObjectContext.SaveChanges()) is broken...</p>
  
  <p>I've debugged into the "Oracle.DataAccess.dll" ( using ILSpy :) ) and found that the mapping code for EF omits the zone (the "Oracle Data Provider" passes the DateTimeOffset.DateTime only). </p>
  
  <p>Does anyone know a workaround?</p>
  
  <p>Thanks in advance
  Eli</p>
  
  <p>BTW: I am using .net4, EF4, Oracle 11g, ODAC 11.2 Release 4 (11.2.0.3.0)</p>