Thinktecture.EntityFrameworkCore

[DEPRECATED]
[EXPERIMENTAL]


[DEPRECATED]

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 [EXPERIMENTAL] | | 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

• Adding custom IRelationalTypeMappingSourcePlugin
• Adding custom IEvaluatableExpressionFilter