AmpScm.RepoDb.SQLite.System
1.2026.302.405
See the version list below for details.
dotnet add package AmpScm.RepoDb.SQLite.System --version 1.2026.302.405
NuGet\Install-Package AmpScm.RepoDb.SQLite.System -Version 1.2026.302.405
<PackageReference Include="AmpScm.RepoDb.SQLite.System" Version="1.2026.302.405" />
<PackageVersion Include="AmpScm.RepoDb.SQLite.System" Version="1.2026.302.405" />
<PackageReference Include="AmpScm.RepoDb.SQLite.System" />
paket add AmpScm.RepoDb.SQLite.System --version 1.2026.302.405
#r "nuget: AmpScm.RepoDb.SQLite.System, 1.2026.302.405"
#:package AmpScm.RepoDb.SQLite.System@1.2026.302.405
#addin nuget:?package=AmpScm.RepoDb.SQLite.System&version=1.2026.302.405
#tool nuget:?package=AmpScm.RepoDb.SQLite.System&version=1.2026.302.405
RepoDb.SQLite.System - a hybrid .NET ORM library for SQLite (using System.Data.SQLite.Core).
RepoDB is an open-source .NET ORM library that bridges the gaps of micro-ORMs and full-ORMs. It helps you simplify the switch-over of when to use the BASIC and ADVANCE operations during the development.
Important Pages
- GitHub Home Page - to learn more about the core library.
- Website - docs, features, classes, references, releases and blogs.
Community Engagements
- GitHub - for any issues, requests and problems.
- StackOverflow - for any technical questions.
- Twitter - for the latest news.
- Gitter Chat - for direct and live Q&A.
Dependencies
- RepoDb - the core library of RepoDB.
- System.Data.SQLite.Core - the data provider used for SQLite (System).
License
- Copyright © 2019 - 2024 Michael Camara Pendon
- Copyright © 2025 - now Bert Huijben
Installation
At the Package Manager Console, write the command below.
> Install-Package AmpScm.RepoDb.SQLite.System
Or, visit our installation page for more information.
Get Started
First, RepoDB must be configured and SqLite support loaded.
GlobalConfiguration.Setup().UseSQLite();
Note: The call must be done once.
After the bootstrap initialization, any library operation can then be called.
Or, visit the official get-started page for 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);
}
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. 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 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. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 is compatible. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETFramework 4.8
- AmpScm.RepoDb (>= 1.2026.302.405)
- Microsoft.Bcl.AsyncInterfaces (>= 10.0.3)
- Microsoft.Bcl.HashCode (>= 6.0.0)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Data.SQLite.Core (>= 1.0.119)
- System.Dynamic.Runtime (>= 4.3.0)
- System.Memory (>= 4.6.3)
- System.Text.Json (>= 10.0.3)
-
.NETStandard 2.0
- AmpScm.RepoDb (>= 1.2026.302.405)
- Microsoft.Bcl.AsyncInterfaces (>= 10.0.3)
- Microsoft.Bcl.HashCode (>= 6.0.0)
- System.ComponentModel.Annotations (>= 5.0.0)
- System.Data.SQLite.Core (>= 1.0.119)
- System.Memory (>= 4.6.3)
- System.Text.Json (>= 10.0.3)
-
net10.0
- AmpScm.RepoDb (>= 1.2026.302.405)
- System.Data.SQLite.Core (>= 1.0.119)
-
net8.0
- AmpScm.RepoDb (>= 1.2026.302.405)
- System.Data.SQLite.Core (>= 1.0.119)
-
net9.0
- AmpScm.RepoDb (>= 1.2026.302.405)
- System.Data.SQLite.Core (>= 1.0.119)
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.2026.309.434 | 42 | 3/9/2026 |
| 1.2026.304.420 | 83 | 3/4/2026 |
| 1.2026.302.405 | 85 | 3/2/2026 |
| 1.15.2602.20384 | 94 | 2/20/2026 |
| 1.15.2512.22350 | 195 | 12/22/2025 |
| 1.14.2508.12328 | 217 | 8/12/2025 |
| 1.14.2508.4318 | 239 | 8/4/2025 |
| 1.14.2507.18312 | 143 | 7/18/2025 |
| 1.14.2507.18302 | 172 | 7/18/2025 |
| 1.14.2507.17297 | 193 | 7/17/2025 |
| 1.14.2507.4263 | 133 | 7/4/2025 |
| 1.14.2507.2257 | 192 | 7/2/2025 |
| 1.14.2506.30251 | 202 | 6/30/2025 |
| 1.14.2506.18235 | 209 | 6/18/2025 |
| 1.14.2506.18231 | 193 | 6/18/2025 |
| 1.14.2506.10222 | 365 | 6/12/2025 |
| 1.14.2506.4209 | 217 | 6/4/2025 |
| 1.14.2505.23170 | 189 | 5/23/2025 |
| 1.14.2505.15147 | 309 | 5/15/2025 |
| 1.14.2505.7144 | 241 | 5/7/2025 |