Hi @shalex
I'm suffering the same problem in version 9.5.520 (Devart Oracle) with EF Core 2.0.3. I just mapped DateTimeOffset fields using as database typing TIMESTAMP WITH TIME ZONE. The result is an exception, passing an invalid timezone value to an instance of DateTimeOffset (valid values are from -14 to 14).
I'm representing the company which I work. To buy the license, I must confirm if that bug will be resolved, and when (date). To run my software in the production environment, DateTimeOffset is required, and no workarounds, that is, the provider must work as is expected (to preserve investment).
I'm waiting answer. Thanks.
More details:
Oracle version: 12.1 (I need support starting from version 10)
using Direct Mode
DateTimeOffset broken in 9.5.502
Re: DateTimeOffset broken in 9.5.502
@denisdbm
We have answered you by email.
We have answered you by email.
Re: DateTimeOffset broken in 9.5.502
@Shalax,
I've answered your e-mail. Please, see it.
I've answered your e-mail. Please, see it.
Re: DateTimeOffset broken in 9.5.502
The bug with using the OracleDbType.TimeStampTZ parameter when working with Oracle 12.1 in the Direct mode is fixed: viewtopic.php?f=1&t=37342.
@denisdbm
We have received your email and are processing it.
@denisdbm
We have received your email and are processing it.