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