support reading Oracles TimestampTZ to NodeTime.ZonedDateTime

[Birgerg]

trafficstars

Hi, I have checked and Oracle's TimestampTZ stores the time zone data (Oracle documentation) My problem with Dapper is that I'm not able to make Dapper recognise the fieldtype as anything but System.DateTime, hence all the oracle TimestampTZ information is lost.

It should be a TypeHandler that upon reading from the db could provide a "callback" withIDataReader and index, fieldname as a parameters. That way DB specific reading could be done without cluttering up Dapper itself with oracle specific code.

Not sure if this is possible to do with only extending Dapper, or if Dapper it self has to be changed, Any thoughts about that ?

[mattjohnsonpint]

Presently I am only supporting SQL Server. Perhaps in the future. I'll leave this open.