[DEPRECATED]



[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.

• 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)
• Bulk Update from Query (SQL Server, PostgreSQL, SQLite)
• Bulk Insert from Query (SQL Server, PostgreSQL, SQLite)

Bulk Delete: EF Core natively supports bulk delete via ExecuteDeleteAsync(). No additional library is needed for this operation.

• 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 and NTile; 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 (SQL Server, SQLite) [DEPRECATED]

• Adding custom IRelationalTypeMappingSourcePlugin
• Adding custom IEvaluatableExpressionFilter