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.
| Provider | Package |
|---|---|
| SQL Server | Thinktecture.EntityFrameworkCore.SqlServer |
| PostgreSQL (Npgsql) | Thinktecture.EntityFrameworkCore.PostgreSQL [EXPERIMENTAL] |
| SQLite | Thinktecture.EntityFrameworkCore.Sqlite |
- 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)
- 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.
- Migrations: include-columns (SQL Server, PostgreSQL)
- Migrations: identity column (SQL Server, PostgreSQL)
- Migrations: (non-)clustered PK (SQL Server)
- Isolation of tests [DEPRECATED]