Nexx.CSharpSqliteORM 1.6.1

.NET 9.0 This package targets .NET 9.0. The package is compatible with this framework or higher. 
dotnet add package Nexx.CSharpSqliteORM --version 1.6.1
                    


                    

                
NuGet\Install-Package Nexx.CSharpSqliteORM -Version 1.6.1
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="Nexx.CSharpSqliteORM" Version="1.6.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="Nexx.CSharpSqliteORM" Version="1.6.1" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="Nexx.CSharpSqliteORM" />
                    


                            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 Nexx.CSharpSqliteORM --version 1.6.1
                    


                    

                
#r "nuget: Nexx.CSharpSqliteORM, 1.6.1"
#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 Nexx.CSharpSqliteORM@1.6.1
#: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=Nexx.CSharpSqliteORM&version=1.6.1
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=Nexx.CSharpSqliteORM&version=1.6.1
                    


                            Install as a Cake Tool

A very simple Sqlite ORM for C#. A projet i made to handle my small projects that require a barebones interface with a sqlite database. NuGet

Examples of syntax

Tables <img width="1110" height="426" alt="image" src="https://github.com/user-attachments/assets/99c6ce15-4099-44d4-a21a-8ebd16c7e358" />

Migrations <img width="772" height="348" alt="image" src="https://github.com/user-attachments/assets/683bc7a3-8681-42f1-b335-e19cb16e2eff" />

Migrations are only for amending an existing database, they are skipped on new databases.

Data modifcation <img width="954" height="214" alt="image" src="https://github.com/user-attachments/assets/f49739ae-74eb-4be4-b49b-58efb23e5ec5" /> <img width="899" height="78" alt="image" src="https://github.com/user-attachments/assets/cb3a5c6e-2d34-424c-a0cd-55f18670d8df" /> <img width="984" height="481" alt="image" src="https://github.com/user-attachments/assets/797f4276-d772-4d54-b94a-67bf6d1a17d8" />

Syntax

Init

To init the database, call the following

  • Init(string location, Action<Exception, string?>? errorCallback = null)

Definition

Creating tables

To create a table create an object that inherits from IDatabase_Table. This requires the table name to be set aswell as the getColums. At the moment the datatypes are:

  • TEXT
  • BIT
  • INTEGER
  • DATETIME
  • GUID
Creating migrations

To create a migration create an object that inherits from IDatabase_Migration. This requires the migration id (a number that determines the order of the migration, ascending) and the sql to run on up.

Functions

Getting Data

You can use:

  • GetItem<T>(SQLFilter.InternalSQLFilter? filter = null, CancellationToken? token = null) where T : IDatabase_Table

  • GetItemsGeneric<T>(string sql, Func<SQLiteDataReader, Task<T>> deserializer, CancellationToken? cancellationToken = null)

  • GetItems<T>(SQLFilter.InternalSQLFilter? filter = null, CancellationToken? token = null) where T : IDatabase_Table

  • GetItemsWithCount<T>(string sql) where T : IDatabase_Table

  • Exists<T>(SQLFilter.InternalSQLFilter? filter = null, CancellationToken? token = null) where T : IDatabase_Table

Product Compatible and additional computed target framework versions.
.NET net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.6.1 91 9/26/2026
1.6.0 78 9/26/2026
1.5.0 90 9/26/2026
1.4.0 88 9/21/2026
1.3.0 206 7/24/2026
1.2.0 113 7/5/2026
1.1.1 113 7/5/2026
1.1.0 111 6/30/2026
1.0.0 119 6/29/2026