Articles

Audit DBContext

AuditDbContext...Definition...AuditDbContext... provides entity change auditing for Entity Framework POCO entities. It lets you easily implement change auditing on your application entities....Instead of using Entity Frameworks DbContext you derive your context from AuditDbContext, which will automatically write change audit records to the database for the registered audit types whenever SaveChanges is called....Implementation...Implement IAuditableEntity on your entity, or use the AuditableEnti...

Audit.NET

Audit.NET...Definition...Audit.NET... is an extensible framework to audit executing operations in .NET applications....It generates an audit log with evidence for reconstruction and examination of activities that have affected specific operations or procedures....AuditScope...The ...AuditScope... is the central object of this framework. It encapsulates an audit event, controlling its lifecycle. The Audit Event is an extensible information container of an audited operation....Create an Audit Scop...

Auto History

AutoHistory...Definition...Microsoft.EntityFrameworkCore.AutoHistory... is a plugin for Microsoft.EntityFrameworkCore to support automatically recording data changes history....AutoHistory records all the data changing history in a table named ...AutoHistories..., this table will recording data UPDATE, DELETE history....Enable AutoHistory...To enable the automatic recording change history, override the ...OnModelCreating... method in your DbContext class and call ...EnableAutoHistory()... extens...

C# Eval Expression

Eval Expression.NET...Definition...The ...Eval-Expression.NET... library allows evaluating, compiling and executing C# code and expression at runtime....It supports nearly everything including:...Anonymous Type...Extension Methods...Generic Type...Lambda Expression...String Interpolation...Eval.Execute...Execute a C# expression and return the result....int result = Eval.Execute<int>("X + Y", new { X = 1, Y = 2}); int result = Eval.Execute<int>(@" var list = new List<int>() { 1, 2, 3, 4, 5 }...

EF Auditing

Auditing...Definition...EFAuditing... is a library that implements Auditing for Entity Framework Core based DbContexts. It is extensible to allow other logging providers like MongoDB, Azure tables etc....Derive you context from AuditDbContext....public partial class MyContext : AuditingDbContext { public MyContext() : base("MyContextDB") { this.Configuration.LazyLoadingEnabled = false; } public DbSet<Customer> Customers { get; set; } public DbSet<Invoice> Invoices { ...

EF Cache

Cache...Definition...EntityFramework.Cache... provides a second level cache for Entity Framework 6.1 and newer....Entity Framework does not currently support caching of query results....A sample EF Caching provider is available for Entity Framework version 5 and earlier but due to changes to the provider model this sample provider does not work with Entity Framework 6 and newer....This library is filling the gap by enabling caching of query results for Entity Framework 6.1 and newer applications...

EF Classic

EF Classic...Definition...Entity Framework Classic is a supported version from the latest EF6 code base. It supports .NET Framework and .NET Core and overcomes some EF limitations by adding tons of must-haves built-in features....Features...Enterprise...Batch SaveChanges...Bulk SaveChanges...Bulk Insert...Bulk Update...Bulk Delete...Bulk Merge...Bulk Synchronize...C# Eval Function...Community...Batch Operations ...Batch Delete...Batch Update...Include ...Also Include...Then Include...Query ...LI...

EF Dynamic Filters

Dynamic Filters...Definition...Entity Framework Dynamic Filters... is a library that Creates global and scoped filters for Entity Framework queries....The filters are automatically applied to every query and can be used to support use cases such as Multi-Tenancy, Soft Deletes, Active/Inactive, etc....How It Works?...The library will add extensions methods automatically to DbContext and DbModelBuilder classes to access ...Dynamic Filters.......Filters are defined in DbContext.OnModelCreating()...

EF Extended

Extended...Definition...EntityFramework.Extended... is a library that improves Entity Framework performance and overcomes limitations with ...MUST-HAVE... features....IMPORTANT:... This library is no longer supported since 2015. We highly recommend you to move to ...Entity Framework Plus.......Features...Batch Update and Delete...Future Queries...Query Result Cache...Audit Log...Batch Update and Delete...A current limitation of the Entity Framework is that to update or delete an entity you have ...

EF Extensions

Entity Framework Extensions...Definition...Entity Framework Extensions... is a library that dramatically improves EF performances by using bulk and batch operations....People using this library often report performance enhancement by 50x times and more!...// Easy to use context.BulkSaveChanges(); context.BulkInsert(list); context.BulkUpdate(list); context.BulkDelete(list); context.BulkMerge(list); // Easy to customize context.BulkMerge(customers, options => options.ColumnPrimaryKeyExpression ...

EF Filters

Filters...Definition...Filters allow you to define a parameterized filter at configuration time. At runtime, you turn on the filter and apply parameters, and every query for that entity will include the filter....Filters are used to define a predicate that will be applied to every entity in a DbContext, without a developer needing to remember to include it for every query. Common applications include:...Security...Multi-tenancy...Logical data partitioning...Soft deletes...Active/inactive records...

EF Plus

Plus...Definition...Entity Framework Plus... is a library that improves Entity Framework performance and overcomes limitations with ...MUST-HAVE... features....Features...Batch Operations ...Batch Delete...Batch Update...LINQ ...LINQ Dynamic...Query ...Cache...Query Deferred...Query DbSetFilter...Query Filter...Query Future...Query IncludeFilter...Query IncludeOptimized...Audit ...Audit...Batch Operations...Batch Operations method allow performing ...UPDATE... or ...DELETE... operation directly ...

EF Utilities

Utilities...Definition...Entity Framework is quite fast in many cases, but doing CRUD operations over many entities is slow. ...EntityFramework.Utilities... provides some batch operations to solve this problem....Utility Methods...EntityFramework.Utilities... provides some helper methods that make certain things easier. Most of them work against context so they should be provider independent....Update Single Value...A simpler API for working with disconnected entities and only updating single va...

LINQ Dynamic

System.Linq.Dynamic...Definition...System.Linq.Dynamic... allows you to express LINQ queries using extension methods that take string arguments instead of type-safe language operators....Dynamic Expression API...The Dynamic Expression API is brought into scope by using (importing) the System.Linq.Dynamic namespace. Below is an example of applying the Dynamic Expression API to a LINQ to SQL data source....var query = db.Customers. Where("City = @0 and Orders.Count >= @1", "London", 10). ...

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 ...

Tracker Enabled DbContext

Tracker Enabled DbContext...Definition...TrackerEnabledDbContext (TEDB) is a .net library based on entity framework. It is created for tracking the changes in database....This library will records new record additions, record changes & record deletions....When recording record modifications, it will audit previous and new values of the fields....It will also audit the time of change and user who changed/added/deleted the record....Configuration...In order to track entities, you will have to spec...