AdaskoTheBeAsT.Dapper.NodaTime.Oracle 6.0.0

.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. .NET Framework 4.7.2 This package targets .NET Framework 4.7.2. The package is compatible with this framework or higher. 
dotnet add package AdaskoTheBeAsT.Dapper.NodaTime.Oracle --version 6.0.0
                    


                    

                
NuGet\Install-Package AdaskoTheBeAsT.Dapper.NodaTime.Oracle -Version 6.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="AdaskoTheBeAsT.Dapper.NodaTime.Oracle" Version="6.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="AdaskoTheBeAsT.Dapper.NodaTime.Oracle" Version="6.0.0" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="AdaskoTheBeAsT.Dapper.NodaTime.Oracle" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add AdaskoTheBeAsT.Dapper.NodaTime.Oracle --version 6.0.0
                    


                    

                
#r "nuget: AdaskoTheBeAsT.Dapper.NodaTime.Oracle, 6.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package AdaskoTheBeAsT.Dapper.NodaTime.Oracle@6.0.0
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=AdaskoTheBeAsT.Dapper.NodaTime.Oracle&version=6.0.0
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=AdaskoTheBeAsT.Dapper.NodaTime.Oracle&version=6.0.0
                    


                            Install as a Cake Tool

AdaskoTheBeAsT.Dapper.NodaTime.Oracle

NuGet

Oracle dialect for AdaskoTheBeAsT.Dapper.NodaTime. It registers the NodaTime type handlers and shapes every parameter with the matching OracleDbType.

Provider client: Oracle.ManagedDataAccess.Core on .NET 8+, Oracle.ManagedDataAccess on .NET Framework.

Installation

dotnet add package AdaskoTheBeAsT.Dapper.NodaTime.Oracle

Usage

using AdaskoTheBeAsT.Dapper.NodaTime.Oracle;
using NodaTime;

OracleDapperNodaTimeSetup.Register(DateTimeZoneProviders.Tzdb);

Call it once during startup. The dialect is public as OracleNodaTimeConfiguration if you want to pass it to DapperNodaTimeSetup.Register yourself.

Parameter mapping

NodaTime type Value written OracleDbType Recommended column
Instant DateTime (UTC) TimeStamp TIMESTAMP
LocalDate DateTime at midnight Date DATE
LocalDateTime DateTime (unspecified) TimeStamp TIMESTAMP
LocalTime TimeSpan since midnight IntervalDS INTERVAL DAY TO SECOND
OffsetDateTime DateTimeOffset TimeStampTZ TIMESTAMP WITH TIME ZONE
Offset int seconds Int32 NUMBER(10)
Duration long nanoseconds Int64 NUMBER(19)
Period ISO8601 roundtrip string Varchar2 VARCHAR2(176)
CalendarSystem calendar id Varchar2 VARCHAR2(50)
DateTimeZone time zone id Varchar2 VARCHAR2(50)

Oracle specifics worth knowing:

  • Oracle has no time-only type, so LocalTime is written as an INTERVAL DAY TO SECOND and read back from the returned TimeSpan.
  • Oracle DATE carries a time component; LocalDate is written at midnight and only the date part is used.
  • TIMESTAMP WITH TIME ZONE preserves the offset, so OffsetDateTime round-trips without normalization.
  • Numeric values arrive as decimal from the provider; Offset and Duration handlers accept that.
CREATE TABLE Events (
    Id NUMBER(19) PRIMARY KEY,
    CreatedAt TIMESTAMP NOT NULL,                       -- Instant (UTC)
    ScheduledAt TIMESTAMP NOT NULL,                     -- LocalDateTime
    EventDate DATE NOT NULL,                            -- LocalDate
    StartTime INTERVAL DAY TO SECOND NOT NULL,          -- LocalTime
    StartsAtWithOffset TIMESTAMP WITH TIME ZONE NULL,   -- OffsetDateTime
    UtcOffsetSeconds NUMBER(10) NULL,                   -- Offset
    RunTimeNanoseconds NUMBER(19) NULL,                 -- Duration
    Recurrence VARCHAR2(176) NULL,                      -- Period
    Calendar VARCHAR2(50) NULL,                         -- CalendarSystem
    TimeZone VARCHAR2(50) NULL)                         -- DateTimeZone

Example

using Dapper;
using NodaTime;
using Oracle.ManagedDataAccess.Client;

using var connection = new OracleConnection(connectionString);

await connection.ExecuteAsync(
    "INSERT INTO Events (Id, CreatedAt, StartTime) VALUES (:Id, :CreatedAt, :StartTime)",
    new
    {
        Id = 1L,
        CreatedAt = SystemClock.Instance.GetCurrentInstant(),
        StartTime = new LocalTime(10, 0),
    });

Oracle uses : for bind parameters; keep BindByName in mind when a command has several parameters.

Target frameworks

net10.0, net9.0, net8.0, net481, net48, net472.

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
.NET Framework net472 is compatible.  net48 is compatible.  net481 is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
6.0.0 37 7/29/2026