Cirreum.Persistence.SQLite 1.0.4

Cirreum.Persistence.SQLite

SQLite provider for Cirreum.Persistence.Sql

Overview

Cirreum.Persistence.SQLite is a SQLite-specific implementation of the ISqlConnectionFactory interface from the Cirreum.Persistence.Sql abstraction layer. It provides:

• SQLite connection factory with Dapper integration
• Health check support for service monitoring
• Integration with the Cirreum Service Provider framework

For query extensions, pagination, transaction chaining, and constraint handling, see the Cirreum.Persistence.Sql documentation.

Installation

dotnet add package Cirreum.Persistence.SQLite

Quick Start

Basic Registration

builder.AddSqlite("default", "Data Source=mydb.sqlite");

With In-Memory Database

builder.AddSqlite("default", "Data Source=:memory:");

With Full Configuration

builder.AddSqlite("default", settings =>
{
    settings.ConnectionString = "Data Source=mydb.sqlite;Cache=Shared";
    settings.CommandTimeoutSeconds = 60;
}, healthOptions =>
{
    healthOptions.Query = "SELECT 1";
    healthOptions.Timeout = TimeSpan.FromSeconds(5);
});

Configuration Options

SqliteInstanceSettings

SqliteHealthCheckOptions

Usage

Inject ISqlConnectionFactory and use the query/command extensions from Cirreum.Persistence.Sql:

public class OrderRepository(ISqlConnectionFactory db)
{
    public async Task<Result<OrderDto>> GetOrderAsync(Guid orderId, CancellationToken ct)
    {
        await using var conn = await db.CreateConnectionAsync(ct);

        return await conn.GetAsync<OrderDto>(
            "SELECT * FROM Orders WHERE OrderId = @Id",
            new { Id = orderId },
            key: orderId,
            ct);
    }

    public async Task<Result<Guid>> CreateOrderAsync(CreateOrder cmd, CancellationToken ct)
    {
        await using var conn = await db.CreateConnectionAsync(ct);
        var orderId = Guid.CreateVersion7();

        return await conn.InsertAndReturnAsync(
            """
            INSERT INTO Orders (OrderId, CustomerId, Amount, CreatedAt)
            VALUES (@OrderId, @CustomerId, @Amount, @CreatedAt)
            """,
            new { OrderId = orderId, cmd.CustomerId, cmd.Amount, CreatedAt = DateTime.UtcNow },
            () => orderId,
            uniqueConstraintMessage: "Order already exists",
            ct: ct);
    }
}

Multiple Instances

Register multiple SQLite instances with different keys:

builder.AddSqlite("primary", "Data Source=primary.sqlite");
builder.AddSqlite("cache", "Data Source=cache.sqlite");

// Inject with [FromKeyedServices]
public class CacheService([FromKeyedServices("cache")] ISqlConnectionFactory db)
{
    // ...
}

DateOnly and TimeOnly Support

This package includes built-in Dapper type handlers for DateOnly and TimeOnly, allowing you to use these types directly in your models and queries:

public record Appointment(int Id, DateOnly Date, TimeOnly StartTime, TimeOnly EndTime);

// Query with DateOnly/TimeOnly parameters
var appointments = await conn.QueryAsync<Appointment>(
    "SELECT * FROM Appointments WHERE Date = @Date AND StartTime > @MinTime",
    new { Date = new DateOnly(2026, 1, 15), MinTime = new TimeOnly(9, 0) });

// Insert with DateOnly/TimeOnly values
await conn.ExecuteAsync(
    "INSERT INTO Appointments (Date, StartTime, EndTime) VALUES (@Date, @StartTime, @EndTime)",
    new { Date = DateOnly.FromDateTime(DateTime.Today), StartTime = new TimeOnly(9, 30), EndTime = new TimeOnly(10, 0) });

The type handlers are registered automatically when the package is loaded.

SQLite Connection Strings

Common SQLite connection string patterns:

Related Packages

License

This project is licensed under the MIT License - see the LICENSE file for details.

Cirreum Foundation Framework Layered simplicity for modern .NET