TinyHelpers.Dapper 3.2.40

Tiny Helpers for Dapper

TinyHelpers.Dapper is a small collection of practical Dapper type handlers for .NET applications.

The package helps reduce repetitive mapping code when your database stores values as JSON, delimited strings, or date/time-specific types.

Compatibility

The package targets:

• .NET Standard 2.0
• .NET 8
• .NET 9
• .NET 10

Notes:

• DateOnlyTypeHandler and TimeOnlyTypeHandler are available only on .NET 6+ targets, so they are not compiled for .NET Standard 2.0.
• JsonTypeHandler<T> can be used with any CLR type that Dapper maps to and from JSON columns.

Installation

Install from NuGet by searching for TinyHelpers.Dapper in Visual Studio Package Manager or using the .NET CLI:

dotnet add package TinyHelpers.Dapper

Contents

• Type handlers
• Usage
• Quick examples
• Contribute

Type handlers

JsonTypeHandler<T>

Reads and writes a CLR type as JSON.

Use it when you want to store a complex object graph in a single column and keep serializer configuration centralized instead of repeating it in each query or repository.

StringArrayTypeHandler

Converts string[] values to a single delimited string.

Use it when a database column stores a small set of string values and you want to work with arrays in your application code.

StringEnumerableTypeHandler

Converts IEnumerable<string> values to a single delimited string.

Use it when you want the consuming code to stay sequence-oriented while still persisting a simple delimited representation.

DateOnlyTypeHandler

Maps DateOnly values to a database date column.

Use it when you want to persist calendar dates without introducing an artificial time component.

TimeOnlyTypeHandler

Maps TimeOnly values to a database time column.

Use it when you want to persist a time of day without tying it to a date.

TimeSpanTypeHandler

Maps TimeSpan values using ticks.

Use it when you want a stable, culture-independent representation for durations.

Usage

Register the handlers at application startup by calling their Configure methods.

JSON mapping

using System.Text.Json;
using TinyHelpers.Dapper.TypeHandlers;

JsonTypeHandler<Person>.Configure(
    new JsonSerializerOptions(JsonSerializerDefaults.Web),
    useUtcDate: true,
    serializeEnumAsString: true);

String collection mapping

using TinyHelpers.Dapper.TypeHandlers;

StringArrayTypeHandler.Configure(",");
StringEnumerableTypeHandler.Configure(",");

Date and time mapping

using TinyHelpers.Dapper.TypeHandlers;

TimeSpanTypeHandler.Configure();

DateOnlyTypeHandler.Configure();
TimeOnlyTypeHandler.Configure();

Quick examples

JSON-backed property mapping

using System.Text.Json;
using TinyHelpers.Dapper.TypeHandlers;

JsonTypeHandler<Metadata>.Configure(
    new JsonSerializerOptions(JsonSerializerDefaults.Web),
    useUtcDate: true,
    serializeEnumAsString: true);

var post = await connection.QuerySingleAsync<Post>(
    "select Id, Metadata from Posts where Id = @Id",
    new { Id = 1 });

String collection mapping

using TinyHelpers.Dapper.TypeHandlers;

StringArrayTypeHandler.Configure(",");

var post = await connection.QuerySingleAsync<Post>(
    "select Id, Tags from Posts where Id = @Id",
    new { Id = 1 });

Date and time mapping

using TinyHelpers.Dapper.TypeHandlers;

DateOnlyTypeHandler.Configure();
TimeOnlyTypeHandler.Configure();
TimeSpanTypeHandler.Configure();

var schedule = await connection.QuerySingleAsync<Schedule>(
    "select StartDate, StartTime, Duration from Schedules where Id = @Id",
    new { Id = 1 });

Contribute

The project is continuously evolving. Contributions, issues, and pull requests are welcome.