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.

The code and the documentation can be found on Thinktecture.EntityFrameworkCore

Use the repo on GitHub to create issues and feature requests.

Performance

• Temp-Tables
• Bulk-Insert
• Bulk-Update
• Bulk-Upsert (Insert-or-Update)
• Truncate Tables

Features

• Collection Parameters (temp-tables light) (SQL Server)
• Window Functions Support (RowNumber, Sum, Average, Min, Max)
• Nested (virtual) Transactions
• Table Hints (SQL Server)
• Queries accross multiple databases (SQL Server)
• Changing default schema at runtime
• If-Exists / If-Not-Exists checks in migrations (SQL Server)

Convenience

• Extension method LeftJoin
• Migrations: include-columns (SQL Server)
• Migrations: identity column (SQL Server)
• Migrations: (non-)clustered PK (SQL Server)

Integration Testing

• Isolation of tests (SQL Server, SQLite)

Extensibility

• Adding custom IRelationalTypeMappingSourcePlugin
• Adding custom IEvaluatableExpressionFilter