EntityFramework-Plus
Entity Framework Plus extends your DbContext with must-haves features: Include Filter, Auditing, Caching, Query Future, Batch Delete, Batch Update, and more
MIT License
Bot releases are hidden (Show)
Published by JonathanMagnan about 7 years ago
Download the library here
PATCH
- FIXED: Audit | Retrieve Deleted Audit #244
- FIXED: EFCore: DateTime in wrong format for sql server to interpret correctly. #243
-
ADDED: EF6: QueryFilter -
QueryFilterManager.AllowPropertyFilter = truenow allow to filter single (non-collection) property.
QueryFilterManager.AllowPropertyFilter = true;
using (var ctx = new EntityContext())
{
ctx.Filter<Invoice>(q => q.Where(x => !x.IsDeleted));
ctx.Filter<InvoiceItem>(q => q.Where(x => !x.IsDeleted));
var list = ctx.InvoiceItems.Where(x => x.Invoice.Total > 400).Include("Invoice").ToList();
}
Published by JonathanMagnan about 7 years ago
Download the library here
MINOR
- ADDED: EF+ Query DbSetFilter for EF6 (Same code as previously before Query Filter switched to interceptor) (Issue #231 #234 )
PATCH
- FIXED: Collection.Count capability doesn't work (Issue #242)
Published by JonathanMagnan about 7 years ago
Download the library here
- ADDED: BatchDelete support for SQLite provider to EF Core (Issue #212)
- ADDED: BatchUpdate support for SQLite provider to EF Core (Issue #212)
- FIXED: Issue with Conditional Expression for BatchUpdate (Issue #195)
Published by JonathanMagnan about 7 years ago
Download the library here
- FIXED: BatchUpdate && DateTime on SQL Server (Issue #209)
- FIXED: BatchUpdate && Oracle (Issue #210)
- FIXED: Auditing && Relationship (Issue #216)
- FIXED: EF Core InMemory for Query Future (Issue #218)
Published by JonathanMagnan about 7 years ago
Download the library here
-
ADDED: Batch Delete - Added
UseTableLockoption -
ADDED: Batch Update- Added
UseTableLockoption -
ADDED: Query Future - Added
AllowQueryBatchoption
QueryFutureManager.AllowQueryBatch = false;
ctx.Activities.Where(a => a.DateCreated < d).Delete(delete => delete.UseTableLock = false );
Published by JonathanMagnan about 7 years ago
Download the library here
- ADDED: Async method for Query Future (Issue #197)
- FIXED: Missing line for cast (Issue #135)
- FIXED: Query Future DataReader was causing some problem in EF Core (Issue #187)
- FIXED: Batch Delete Executing at wrong place (Issue #198)
- FIXED: MySQL escape for BatchUpdate (Issue #201)
- FIXED: GetModel for custom connection (Issue #202)
Published by JonathanMagnan about 7 years ago
Download the library here
- ADDED: QueryFutureManager.ExecuteBatch(ctx) (Issue #190)
- ADDED: QueryFutureValue && Implicit conversion (Pull #189)
- FIXED: Include Filter && Case (Issue #135)
- FIXED: Batch Update with property without using a calculated value (Issue #191)
Thank you @Immelstorn for your contribution with the pull #189
Published by JonathanMagnan over 7 years ago
Download the library here
- ADDED: QueryCache - IsCommandInfoOptionalForCacheKey (Require UseTagsAsCacheKey or UseFirstTagAsCacheKey enabled)
When this option is enabled, all information from command become optional (Connection && CommandText). They are only included if there are found. It allows caching any kind of list even when not coming from Entity Framework.
var listA = new List<CustomEntity>() { new CustomEntity() { X = 1 }, new CustomEntity() { X = 2 }, new CustomEntity() { X = 3 }};
var listB = new List<CustomEntity>() { new CustomEntity() { X = 4 }, new CustomEntity() { X = 5 }, new CustomEntity() { X = 6 } };
QueryCacheManager.IsCommandInfoOptionalForCacheKey = true;
QueryCacheManager.UseTagsAsCacheKey = true;
var t1 = listA.AsQueryable().FromCache("a");
var t2 = listB.AsQueryable().FromCache("a");