Articles

Audit

Audit...Introduction...The audit allows you to log changes from Entity Framework change tracker in a database or log file....Why Audit?...Entity Framework saves entities in a database but doesn't let you easily track changes. To follow all the changes, you will need to use a third-party library....Common scenario:...To keep a history of changes in a database or a log file...Track What/Who/When a modification occurs...Show historical data changes in a grid...Google Related Questions...Entity Fram...

Batch Delete

Batch Delete...Introduction...Batch Delete allows you to improve EF performance by deleting multiple records in a database from a LINQ Query without loading entities....Why Batch Delete?...For ...HUGE... performance gains, everything is executed on the database side. To use batch delete, you will need to use a third-party library....Google Related Searches...Entity Framework Delete Without Loading...Entity Framework Delete Without Retrieving...StackOverflow Related Questions...How do I delete mu...

Batch Update

Batch Update...Introduction...Batch Update allows you to improve EF performance by updating multiple records in a database from a LINQ Query without loading entities....Why Batch Delete?...For ...HUGE... performance gains, everything is executed on the database side. To use batch update, you will need to use a third-party library....Google Related Searches...Entity Framework Update Without Loading...Entity Framework Update Without Retrieving...StackOverflow Related Questions...How to Bulk Update...

Bulk Delete

Bulk Delete...Introduction...BulkDelete allows you to improve EF performance by deleting multiple entities with bulk operations....Why BulkDelete?...For ...HUGE... performance gains, Entity Framework makes one database round-trip for each entity to delete....So if you want to modify 10,000 entities, 10,000 database round trip will be required which is ...INSANELY... slow. To use BulkDelete, you will need to use a third-party library....Operations...1,000 Entities...2,000 Entities...5,000 Entitie...

Bulk Insert

Bulk Insert...Introduction...BulkInsert allows you to improve EF performance by inserting multiple entities with bulk operations....Why BulkInsert?...For ...HUGE... performance gains, Entity Framework makes one database round-trip for each entity to insert....So if you want to add 10,000 entities, 10,000 database round trip will be required which is ...INSANELY... slow. To use BulkInsert, you will need to use a third-party library....Operations...1,000 Entities...2,000 Entities...5,000 Entities....

Bulk Merge

Bulk Merge...Introduction...BulkMerge allows you to improve EF performance by merging multiple entities with bulk operations....Why BulkMerge?...For ...HUGE... performance gains, Entity Framework makes one database round-trip for each entity to insert/update....So if you want to modify 10,000 entities, 10,000 database round trip will be required which is ...INSANELY... slow. To use BulkMerge, you will need to use a third-party library....Operations...1,000 Entities...2,000 Entities...5,000 Entit...

Bulk Save Changes

BulkSaveChanges...Introduction...BulkSaveChanges allows you to improve EF performance by saving multiple entities with bulk operations....Why BulkSaveChanges?...For ...HUGE... performance gains, Entity Framework makes one database round-trip for each entity to insert/update/delete....So if you want to save (add, modify or remove) 10,000 entities, 10,000 database round trip will be required which is ...INSANELY... slow. To use BulkSaveChanges, you will need to use a third-party library....Operati...

Bulk Update

Bulk Update...Introduction...BulkUpdate allows you to improve EF performance by updating multiple entities with bulk operations....Why BulkUpdate?...For ...HUGE... performance gains, Entity Framework makes one database round-trip for each entity to update....So if you want to modify 10,000 entities, 10,000 database round trip will be required which is ...INSANELY... slow. To use BulkUpdate, you will need to use a third-party library....Operations...1,000 Entities...2,000 Entities...5,000 Entitie...

Cache

Cache...Introduction...Cache library allow you to cache the result of a LINQ query, usually in the memory, and re-use the cached result for subsequent calls....Why Cache?...Common Scenarios:...Cache read-only table like countries and states...Cache rarely modified table (most libraries allow cache expiration)...Cache information related to the user logged...Google Related Searches...Entity Framework Caching Data...Entity Framework First Level Cache...Entity Framework Second Level Cache...StackOv...

Deferred Query

Deferred Query...Introduction...Deferred Query allows you to defer immediate query execution from a LINQ method, like First or Count, to allow other third-party libraries to use their features like caching....Why Deferred Query?...Common scenario:...Allow other third-party libraries to use LINQ immediate method...Google Related Searches...Entity Framework Deferred Execution...Entity Framework Deferred vs Immediate Query Execution...StackOverflow Related Questions...Entity Framework flexible cach...

Dynamic Query

Dynamic Query...Introduction...Dynamic Query allows you to perform dynamic where clause, select, order by, with string expression at runtime....Why Dynamic Query?...Common Scenarios:...Use dynamic select clause with string expression...Use dynamic order by with string expression...Use dynamic where clause with string expression...Google Related Searches...Entity Framework Dynamic LINQ...Entity Framework Dynamic Where Clause...Entity Framework OrderBy String...StackOverflow Related Questions...Bu...

Filter

Filter...Introduction...Filter allows you to filter data from the DbContext with predefined filters....Why Filters?...Common Scenarios:...Default Ordering...Logical Data Partitioning...Multi-Tenancy...Soft Deleted...Security Access...Google Related Searches...Entity Framework Dynamic Filter...Entity Framework Global Filter...Entity Framework Soft Delete Filter...StackOverflow Related Questions...Filter all tables on Context Level...// using Z.EntityFramework.Plus; // Don't forget to include this...

Future

Future...Introduction...Future feature allows you to batches multiple LINQ queries to be executed in one SQL Command to perform only a single database round trip....Why using Future with Entity Framework?...Common Scenarios:...Reduce the number of database round trip...Google Related Searches...Entity Framework Future Query...Entity Framework Future Value...// using Z.EntityFramework.Plus; // Don't forget to include this. var ctx = new EntitiesContext(); // CREATE a pending list of future queri...

Include Filter

Include Filter...Introduction...IncludeFilter allows you to add a method similar to EF Include but with a predicate to filter related entities....Why IncludeFilter?...Common Scenarios:...Logical Data Partitioning...Multi-Tenancy...Soft Deleted...Security Access...Google Related Searches...Entity Framework Include Filter Child Collection...Entity Framework Include Where Clause...Entity Framework Filter Related Entities...StackOverflow Related Questions...How to filter "Include" entities in entity...

Include Optimized

Include Optimized...Introduction...IncludeOptimized allows you to optimize the query generated by EF by executing multiple smaller queries instead of executing only one monster SQL....Why IncludeOptimized?...Common Scenarios:...The SQL generated by Entity Framework is too big and take several seconds or minutes to be executed....Google Related Searches...Entity Framework Include Performance...Entity Framework Include Slow...// SELECT * FROM Order WHERE.... // SELECT * FROM OrderItem WHERE EXISTS...

Third Party Libraries

Third Party Libraries...Introduction...Entity Framework ...Third Party Libraries... allow you to extend EF functionality which is not available in the official Entity Framework library, for example, auditing, caching, and filtering etc....Why we need Third Party Libraries?...Entity Framework is great, but a lot of essential features is missing for some application scenarios....The only way to achieve is either create code for this kind of scenario or use a library which fully or partially cover ...