nextorm.sqlite 1.0.9

.NET 10.0

dotnet add package nextorm.sqlite --version 1.0.9

NuGet\Install-Package nextorm.sqlite -Version 1.0.9

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="nextorm.sqlite" Version="1.0.9" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="nextorm.sqlite" Version="1.0.9" />
                    

                            Directory.Packages.props

<PackageReference Include="nextorm.sqlite" />
                    

                            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 nextorm.sqlite --version 1.0.9

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: nextorm.sqlite, 1.0.9"

#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 nextorm.sqlite@1.0.9

#: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=nextorm.sqlite&version=1.0.9
                    

                            Install as a Cake Addin

#tool nuget:?package=nextorm.sqlite&version=1.0.9
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Nextorm — SQLite provider

nextorm.sqlite adds SQLite support to Nextorm — a zero-SQL object-relational mapper for .NET that turns typed C# queries into SQL and materializes rows without change tracking. The package supplies the SQLite dialect and the UseSqlite builder extension over Microsoft.Data.Sqlite.

Installation

All current nextorm releases are prereleases, so --prerelease is required:

dotnet add package nextorm --prerelease
dotnet add package nextorm.sqlite --prerelease

Package Manager Console: Install-Package nextorm -Prerelease and Install-Package nextorm.sqlite -Prerelease.

Usage

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using NextORM.Core;
using NextORM.Sqlite;

var builder = new DataContextBuilder().UseSqlite("app.db");
using var dataContext = builder.CreateDataContext();

await foreach (var row in dataContext.From<IOrder>()
                                     .Where(order => order.Total > 100)
                                     .Select(order => new { order.Id, order.Total })
                                     .ToAsyncEnumerable())
{
    Console.WriteLine($"{row.Id}: {row.Total}");
}

[SqlTable("orders")]
public interface IOrder
{
    [Key]
    [Column("id")]
    int Id { get; set; }

    [Column("total")]
    decimal Total { get; set; }
}

Values are bound as $name parameters and paging renders limit/offset. UseSqlite also accepts an open DbConnection when you want to own the connection yourself.

Good to know

Paging renders limit/offset, and DateTime.Now/UtcNow render datetime('now') — SQLite has no now().
Custom stdev/var aggregates are registered on every connection the context creates.
FTS5 maintenance (merge, optimize, rebuild) is a SQLite-only command surface; stored procedures, row locks and CrossApply/OuterApply are rejected with NotSupportedException.

Documentation

Status

Beta: every release so far is a prerelease, the public API still changes between them, and backward compatibility is not preserved yet. Release notes are on GitHub Releases.

License

MIT

Product	Compatible and additional computed target framework versions.
.NET	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. net11.0 is compatible.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net10.0
- Microsoft.Data.Sqlite (>= 10.0.12)
- nextorm (>= 1.0.9)
- SQLitePCLRaw.bundle_e_sqlite3 (>= 3.0.5)
net11.0
- Microsoft.Data.Sqlite (>= 10.0.12)
- nextorm (>= 1.0.9)
- SQLitePCLRaw.bundle_e_sqlite3 (>= 3.0.5)

NuGet packages (1)

Showing the top 1 NuGet packages that depend on nextorm.sqlite:

Package	Downloads
nextorm.entityframeworkcore Entity Framework Core integration for Nextorm, a zero-SQL ORM for .NET: run nextorm queries and commands over an existing DbContext connection and transaction, reusing the EF model mapping. Adds CreateNextOrmContext().	81

GitHub repositories

This package is not used by any popular GitHub repositories.

Version	Downloads	Last Updated
1.0.9	87	11/11/2026
1.0.9-rc5	130	11/8/2026
1.0.9-rc4	72	10/29/2026
1.0.9-rc3	73	10/20/2026
1.0.9-rc2	72	10/10/2026
1.0.9-rc1	70	10/7/2026
1.0.9-b	74	10/5/2026
1.0.9-a	73	9/29/2026
1.0.8-b	77	9/27/2026
1.0.7-b	77	9/25/2026
1.0.6-alpha	67	9/25/2026
1.0.5-alpha	66	9/24/2026
1.0.4-alpha	67	9/22/2026
1.0.3.1-alpha	73	9/22/2026
1.0.3-alpha	76	9/21/2026
1.0.2-alpha	79	9/16/2026
1.0.1-alpha.147	204	1/9/2024

https://github.com/AlexeyShirshov/nextorm/releases