Info
| Version: | 2.0.2 |
| Author(s): | Simon Mourier |
| Last Update: | Friday, August 11, 2023 |
| .NET Fiddle: | Create the first Fiddle |
| Project Url: | https://github.com/smourier/SQLNado |
| NuGet Url: | https://www.nuget.org/packages/SqlNado |
Install
Install-Package SqlNado
dotnet add package SqlNado
paket add SqlNado
SqlNado Download (Unzip the "nupkg" after downloading)
Dependencies
Tags
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).