RepoDb.Sqlite.Ahtola 0.0.1-alpha1

<div align="center"> <a href="https://github.com/mikependon/RepoDB/tree/master/src/Providers/RepoDb.Sqlite.Ahtola"><image src="SQLite.png" style="width:256px;" /></a> <br/> <span style="font-size:28px;font-weight:bold;"><a href="https://github.com/mikependon/RepoDB/tree/master/src/Providers/RepoDb.Sqlite.Ahtola"><strong>RepoDb.Sqlite.Ahtola</strong></a></span> <br/> <span style="font-size:16px;">A high-performance data productivity platform for Ahtola (SQLite-compatible) in .NET.</span> </div>

<br/>

RepoDb.Sqlite.Ahtola — RepoDB for Ahtola (Devolutions.Ahtola.Data.Sqlite)

The Ahtola provider for RepoDB — a fast, lightweight .NET ORM that lets you use raw SQL and fluent operations side by side on the same connection. Built on top of RepoDb and Devolutions.Ahtola.Data.Sqlite.

Important Pages

• GitHub Home — core library and source code.
• Website — full documentation, API reference, and blog.

Community

• GitHub Issues — bug reports and feature requests.
• Microsoft Teams — live Q&A.
• GitHub Discussions — ask questions and share ideas.
• X / Twitter — news and updates.

Dependencies

• Devolutions.Ahtola.Data.Sqlite — Ahtola data provider.
• RepoDb — the RepoDB core library.

License

Apache-2.0 — Copyright © 2019 Michael Camara Pendon, Marc-André Moreau

Installation

Install-Package RepoDb.Sqlite.Ahtola

Or visit the installation page for more options.

Get Started

Initialize the bootstrapper once at application startup:

GlobalConfiguration
    .Setup()
    .UseAhtola();

Then use any RepoDB operation directly on your SqliteConnection (using Ahtola.Data.Sqlite;):

Query

using (var connection = new SqliteConnection(ConnectionString))
{
	var customer = connection.Query<Customer>(c => c.Id == 10045);
}

Insert

var customer = new Customer
{
	FirstName = "John",
	LastName = "Doe",
	IsActive = true
};
using (var connection = new SqliteConnection(ConnectionString))
{
	var id = connection.Insert<Customer>(customer);
}

Update

using (var connection = new SqliteConnection(ConnectionString))
{
	var customer = connection.Query<Customer>(10045);
	customer.FirstName = "John";
	customer.LastUpdatedUtc = DateTime.UtcNow;
	var affectedRows = connection.Update<Customer>(customer);
}

Delete

using (var connection = new SqliteConnection(ConnectionString))
{
	var customer = connection.Query<Customer>(10045);
	var deletedCount = connection.Delete<Customer>(customer);
}

ExecuteQuery

using (var connection = new SqliteConnection(ConnectionString))
{
	var customer = connection.ExecuteQuery<Customer>("SELECT * FROM [Customer] WHERE (Id = @Id);", new { Id = 10045 }).FirstOrDefault();
}

ExecuteNonQuery

using (var connection = new SqliteConnection(ConnectionString))
{
	var affectedRows = connection.ExecuteNonQuery("UPDATE [Customer] SET FirstName = @FirstName WHERE (Id = @Id);", new { FirstName = "John", Id = 10045 });
}

ExecuteScalar

using (var connection = new SqliteConnection(ConnectionString))
{
	var count = connection.ExecuteScalar<int>("SELECT COUNT(*) FROM [Customer];");
}

Visit the get-started page for the full SQLite guide; the same usage applies to Ahtola.

License

Apache-2.0 — Copyright © 2026 Michael Camara Pendon and Marc-André Moreau