Entity Framework Plus Overview
Definition
Entity Framework Plus is a library that Improve Entity Framework performance and overcome limitations with MUST-HAVE features.
Features
- Batch Operations
- LINQ
- Query
- Audit
Installing & Upgrading
Download the NuGet Package
Requirements
Entity Framework Version
- Entity Framework Core 2.x
- Entity Framework 6.x
- Entity Framework 5
Database Provider
- SQL Server 2008+
- SQL Azure
- SQL Compact
- Oracle
- MySQL
- PostgreSQL
- SQLite
Batch Operations
Batch Operations method allow to perform UPDATE or DELETE operation directly in the database using a LINQ Query without loading entities in the context.
Everything is executed on the database side to let you get the best performance available.
LINQ
LINQ Dynamic in Entity Framework is supported through the Eval-Expression.NET Library.
Query
Query Cache
Query cache is the second level cache for Entity Framework.
The result of the query is returned from the cache. If the query is not cached yet, the query is materialized and cached before being returned.
Query Deferred
Defer the execution of a query which is normally executed to allow some features like Query Cache and Query Future.
Query Filter
Filter query with predicate at global, instance or query level.
Query Future
Query Future allow to reduce database roundtrip by batching multiple queries in the same sql command.
All future queries are stored in a pending list. When the first future query requires a database roundtrip, all queries are resolved in the same sql command instead of making a database roundtrip for every sql command.
Query IncludeFilter
Entity Framework already support eager loading. However, the major drawback is you cannot control what will be included. There is no way to load only active items or load only the first 10 comments.
Query IncludeOptimized
Improves SQL generated by Include and filter child collections at the same time!
Audit
Allow to easily track changes, exclude/include entity or property and auto save audit entries in the database.
Contribute
The best way to contribute is by spreading the word about the library:
- Blog it
- Comment it
- Fork it
- Star it
- Share it
A HUGE THANKS for your help.