Skip to main content
SqlNado package icon

SqlNado

SQLNado (SQLite Not ADO) is a .NET lightweight bloat free object persistence framework based on SQLite. SQLNado supports all of SQLite features when using SQL commands, and also supports most of SQLite features through .NET: * Automatic class-to-table mapping (Save, Delete, Load, LoadAll, LoadByPrimaryKey, LoadByForeignKey, etc.) * Automatic synchronization of schema (tables, columns) between classes and existing table * Designed for thread-safe operations * Where and OrderBy LINQ/IQueryable .NET expressions are supported (work is still in progress in this area), also with collation support * SQLite database schema (tables, columns, etc.) exposed to .NET * SQLite custom functions can be written in .NET * SQLite incremental BLOB I/O is exposed as a .NET Stream to avoid high memory consumption * SQLite collation support, including the possibility to add custom collations using .NET code * SQLite Full Text Search engine (FTS3/4) support, including the possibility to add custom FTS3 tokenizers using .NET code * Automatic support for Windows 'winsqlite3.dll' to avoid shipping any binary file (supported on azure web apps).

Total Downloads
19.0K
18,959
Published
Jan 16, 2019
Latest stable version

Install

.NET CLI
dotnet add package SqlNado --version 1.2.0
Package Manager Console
Install-Package SqlNado -Version 1.2.0
PackageReference
<PackageReference Include="SqlNado" Version="1.2.0" />

Frameworks

.NETStandard2.0

Dependencies

No declared dependencies.

Adoption guide

Assess this package against its supported frameworks, license, maintenance signals and dependency graph before making it a project standard.

No SPDX license expression is published. Review the license text and your organisation's policy before redistribution.

Compatibility metadata lists 1 target framework; confirm the exact target used by your application.

How to read this guidance

Sources: published NuGet v3 registry metadata and explicit NuBrowse editorial guides. Refresh: package metadata is refreshed from NuGet when the page loads. Limit: this is not a security, legal or compatibility guarantee; validate the selected version in your project.

Useful next steps

Move from package metadata to a concrete selection or review workflow.