Dapper Plus 使用批量操作方法擴展 IDbConnection接口:
- 批量插入
- 批量更新
- 批量刪除
- 批量合併
此庫是在數據庫中執行保存操作的最快方法 。
Mapper
Dapper Plus Mapper allow to map the conceptual model (Entity) with the storage model (Database) and configure options to perform Bulk Actions. An entity can be mapped more than once using a MappingKey.
- Map
Bulk Actions
Bulk Actions allow to perform a bulk insert, update, delete or merge and include related child items.
- Bulk Insert
- Bulk Update
- Bulk Delete
- Bulk Merge
Also Bulk Actions
Also Bulk Actions allow to perform bulk action with a lambda expression using entities from the last Bulk[Action] or ThenBulk[Action] used.
- Also Bulk Insert
- Also Bulk Update
- Also Bulk Delete
- Also Bulk Merge
Then Bulk Actions
Then Bulk Actions is similar to Also Bulk Actions but move foward the chaining for the next bulk action.
- Then Bulk Insert
- Then Bulk Update
- Then Bulk Delete
- Then Bulk Merge
Utilities Actions
The Dapper Plus utilities give you more flexibility to control chaining methods.
- Include
- ThenForEach
Dapper Plus與所有主要數據庫提供商兼容:
- SQL Server 2008+
- SQL Azure
- SQL Compact
- Oracle
- MySQL
- PostgreSQL
- SQLite
Entity Framework Classic
Entity Framework Classic is an EF6 fork. It's everything you like about EF6, but with better performance, must-have features, .NET Core support, and more.
Entity Framework Extensions
Entity Framework Extensions extends your DbContext with high-performance bulk operations: BulkSaveChanges, BulkInsert, BulkUpdate, Bulk12Delete, BulkMerge, and more.
Bulk Operations
Overcome SqlBulkCopy limitations by adding high-performance bulk operations: BulkInsert, BulkUpdate, BulkDelete, BulkMerge, and more.
C# Eval Expression
C# Eval Expression is an Eval function. You can Evaluate, Compile and Execute C# code at runtime.
SQL Eval Function
SQL Eval Function is a C# expression evaluator. You can evaluate arithmetic expressions, regex, and more directly in T-SQL.