DateTimeOffset and "Specified cast is not valid"

[ron_grove]

I'm working against a database with a lot of last modified fields defined like this:

Code: Select all

MODIFIED_DATE Timestamp With Time Zone DEFAULT SYSDATE NOT NULL

The linqConnect drivers are identifying this as the type DateTimeOffset which consistently results in InvalidCastExceptions being raised until I change it manually to DateTime. It's can be worked around in my own model by changing the type of course, but I'd like to use LINQPad. When LINQPad gets the schema using the LinqConnect Oracle driver it has the same problem with DateTimeOffset. I can only get a result set if I specifically exclude last modified dates, but they're pretty important so that's not so useful. This is a third party database so I have no control over the fields and have to work with them as is.

Thank you,
Ron

[MariiaI]

Thank you for the report. We have reproduced this issue. We will investigate it and inform you about the results as soon as possible.

[MariiaI]

The support for correct retrieving of the TimeSpan and DateTimeOffset values while materializing is added. The changes will be available in the next build of dotConnect for Oracle. We will inform you when it is available for download.

[ron_grove]

Thank you. Hopefully it'll be out soon. I've had to do pretty much everything in SQL so far because of this.

[Shalex]

We are going to release the new build this week. We will post here when it is available for download.

[Helen]

New version of dotConnect for Oracle 7.9 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).

For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=27875 .