AdaskoTheBeAsT.Dapper.NodaTime 1.0.3

AdaskoTheBeAsT.Dapper.NodaTime

Noda Time support for Dapper - unofficial fork of Dapper-NodaTime project which development stopped some time ago. Matt Johnson-Pint is original author and maintainer of Dapper-NodaTime project. This is continuation of his work. Refreshed for currently available .NET versions.

Badges

Installation

Install-Package AdaskoTheBeAsT.Dapper.NodaTime

In your project startup sequence somewhere, call:

DapperNodaTimeSetup.Register(<provider>);

Provider is one of the following date time zone providers:

1. DateTimeZoneProviders.Tzdb - IANA Time Zone Database
2. DateTimeZoneProviders.Bcl - Windows registry

That registers all of the type handlers. Alternatively, you can register each type handler separately if you wish. For example:

SqlMapper.AddTypeHandler(LocalDateTimeHandler.Default);

Work in progress. Currently supports the following types:

• CalendarSystem - can be mapped to varchar(50)
• DateTimeZone - can be mapped to varchar(50)
• Duration - can be mapped to bigint
• Instant - can be mapped to datetime, datetime2, datetimeoffset
• LocalDate - can be mapped to date, datetime, datetime2
• LocalDateTime - can be mapped to datetime, datetime2
• LocalTime - can be mapped to time, datetime, datetime2
• Offset - can be mapped to int
• OffsetDateTime - can be mapped to datetimeoffset
• Period - can be mapped to varchar(195) Max length of period is 195 characters. It is written as for example "Y:-2147483648 M:-2147483648 W:-2147483648 D:-2147483648 h:-9223372036854775808 m:-9223372036854775808 s:-9223372036854775808 ms:-9223372036854775808 t:-9223372036854775808 ns:-9223372036854775808"

Where:

• Y - years
• M - months
• W - weeks
• D - days
• h - hours
• m - minutes
• s - seconds
• ms - milliseconds
• t - ticks
• ns - nanoseconds

Does not support:

• ZonedDateTime (although there is trick to keep properties separated and then by using mapping code or AutoMapper (or other mapper) compose ZoneDateTime from LocalDateTime, CalendarSystem and DateTimeZone)