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