Thinktecture.EntityFrameworkCore.Sqlite.Testing
10.2.0
dotnet add package Thinktecture.EntityFrameworkCore.Sqlite.Testing --version 10.2.0
NuGet\Install-Package Thinktecture.EntityFrameworkCore.Sqlite.Testing -Version 10.2.0
<PackageReference Include="Thinktecture.EntityFrameworkCore.Sqlite.Testing" Version="10.2.0" />
<PackageVersion Include="Thinktecture.EntityFrameworkCore.Sqlite.Testing" Version="10.2.0" />
<PackageReference Include="Thinktecture.EntityFrameworkCore.Sqlite.Testing" />
paket add Thinktecture.EntityFrameworkCore.Sqlite.Testing --version 10.2.0
#r "nuget: Thinktecture.EntityFrameworkCore.Sqlite.Testing, 10.2.0"
#:package Thinktecture.EntityFrameworkCore.Sqlite.Testing@10.2.0
#addin nuget:?package=Thinktecture.EntityFrameworkCore.Sqlite.Testing&version=10.2.0
#tool nuget:?package=Thinktecture.EntityFrameworkCore.Sqlite.Testing&version=10.2.0
Thinktecture.EntityFrameworkCore
These libraries extend Entity Framework Core by a few features to make it easier to work with EF and for easier integration testing or to get more performance in some special cases.
Supported Providers
| Provider | Package |
|---|---|
| SQL Server | Thinktecture.EntityFrameworkCore.SqlServer |
| PostgreSQL (Npgsql) | Thinktecture.EntityFrameworkCore.PostgreSQL |
| SQLite | Thinktecture.EntityFrameworkCore.Sqlite |
Performance
- Temp-Tables (SQL Server, PostgreSQL, SQLite)
- Bulk-Insert (SQL Server, PostgreSQL, SQLite)
- Bulk-Update (SQL Server, PostgreSQL, SQLite)
- Bulk-Upsert (Insert-or-Update) (SQL Server, PostgreSQL, SQLite)
- Truncate Tables (SQL Server, PostgreSQL, SQLite)
Features
- Collection Parameters (temp-tables light) (SQL Server, PostgreSQL)
- Window Functions Support (RowNumber, Sum, Average, Min, Max) (SQL Server, PostgreSQL, SQLite*)
- Nested (virtual) Transactions
- Table Hints (SQL Server)
- Queries across multiple databases (SQL Server)
- Changing default schema at runtime
- If-Exists / If-Not-Exists checks in migrations (SQL Server, PostgreSQL)
* SQLite supports RowNumber only; Sum, Average, Min, Max are available on SQL Server and PostgreSQL.
Convenience
- Migrations: include-columns (SQL Server, PostgreSQL)
- Migrations: identity column (SQL Server, PostgreSQL)
- Migrations: (non-)clustered PK (SQL Server)
Integration Testing
- Isolation of tests [DEPRECATED]
Extensibility
AI Coding Assistants
An AI agent skill ships with the repository (under skills/thinktecture-entityframeworkcore) to teach AI coding agents how to consume these packages. Install it with the skills CLI:
npx skills@latest add PawelGerr/Thinktecture.EntityFrameworkCore
The library is also indexed by Context7 (MCP) under the id /pawelgerr/thinktecture.entityframeworkcore. See AI Coding Assistants for details.
| Product | Versions 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. |
-
net10.0
- Thinktecture.EntityFrameworkCore.Sqlite.Core (>= 10.2.0)
- Thinktecture.EntityFrameworkCore.Testing (>= 10.2.0)
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 |
|---|---|---|
| 10.2.0 | 0 | 6/18/2026 |
| 10.2.0-beta02 | 90 | 6/5/2026 |
| 10.2.0-beta01 | 94 | 6/1/2026 |
| 10.1.0 | 197 | 5/16/2026 |
| 10.1.0-beta03 | 111 | 3/3/2026 |
| 10.1.0-beta02 | 106 | 2/20/2026 |
| 10.1.0-beta01 | 112 | 2/16/2026 |
| 10.0.2 | 1,379 | 2/22/2026 |
| 10.0.1 | 2,583 | 2/6/2026 |
| 10.0.1-beta-1 | 105 | 2/5/2026 |
| 10.0.0 | 3,297 | 11/11/2025 |
| 10.0.0-beta03 | 212 | 10/20/2025 |
| 10.0.0-beta02 | 210 | 10/15/2025 |
| 10.0.0-beta01 | 190 | 10/9/2025 |
| 9.2.1 | 1,482 | 1/22/2025 |
| 9.2.0 | 224 | 1/6/2025 |
| 9.1.0 | 186 | 12/4/2024 |
| 9.0.1 | 2,529 | 11/22/2024 |
| 8.4.0 | 3,550 | 1/6/2025 |
| 8.3.0 | 209 | 12/4/2024 |