Linqpad doesn't work very well if the underlying columns in an Oracle database contain TIMESTAMP WITH TIME ZONE columns.

These appear in the datacontext as DateTime (losing the offset information), however queries using equality checks against them can fail due to the way the underlying IQDriver handles (or otherwise) the conversion back to datetime offset within Oracle.

It's a bit of a pain, but one of the simple approaches is to ensure the generated SQL wraps those columns in either sysextractutc(theColumn) or 'theColumn AT TIME ZONE xxxx' to ensure they are compared with the DateTime parameter that is bound to the query.

Obviously the better solution would be to implement them 'properly' (map to / from DateTimeOffset), but that might be more complicated

The menu item for "Copy for Markdown/Stack Overflow" ends up copying code that in most cases won't compile without manual intervention by the person who grabs it off of Stack Overflow.

Specifically, these two things is on the query options tab, and has to be manually added for the query code to compile and execute:

• References


• Using directives

It would be nice if those two things could be copied alongside the query code, for instance as specially crafted comments at the top, that would be recognized by LINQPad upon pasting back into it, and moved to the appropriate places.

ie.

// reference: <RuntimeDirectory>System.Runtime.Numerics

using System.Runtime.Numerics;