R8.EntityFrameworkCore.AuditProvider 1.0.0

R8.EntityFrameworkCore.AuditProvider

A .NET 6 package for Entity Framework, providing comprehensive change tracking with deep insights. Capture creation, updates, deletions, and restorations of entities, including property names, old and new values, stack traces, and user details, all neatly stored in an Audits column as JSON.

Seamless Entity Auditing: Easily integrate audit functionality into your Entity Framework applications, offering a complete audit trail enriched with stack traces and user information. Gain full visibility into entity lifecycle changes for compliance, debugging, and accountability.

Full Entity Lifecycle Visibility: Track and visualize the complete life cycle of your entities with detailed auditing. In addition to changes, this package records the stack trace of changes and user actions, enabling a deeper understanding of data evolution and robust audit trails.

Installation

Step 1:

// ... other services

// Add AuditProvider
services.AddEntityFrameworkAuditProvider(options =>
{
    // Your options here (See Options section)
});

services.AddDbContext<YourDbContext>((serviceProvider, optionsBuilder) =>
{
    // Your DbContext connection configuration here
    ...
    
    // Add AuditProviderInterceptor
    optionsBuilder.AddEntityFrameworkAuditProviderInterceptor(serviceProvider);
});

Step 2:

• Implement IAuditable (and IAuditableDelete) in your Aggregate Auditable Entity (Or you can implement IAuditable/IAuditableDelete in your Entity directly):
  • Example for PostgreSQL: AggregateAuditable.cs
  • Example for Microsoft Sql Server: AggregateAuditable.cs
• then inherit your entity from AggregateAuditable:

public record YourEntity : AggregateAuditable
{
    // Your entity properties
    // ...
    public string FirstName { get; set; }
    
    [IgnoreAudit] // Ignore this property from audit
    public string LastName { get; set; }
    
    // ...
}

• Deleted and UnDeleted flags would be stored, only if IAuditableDelete implemented.
• Flags Created/Changed cannot be done simultaneously with Deleted/UnDeleted.

Step 3:

Migrate your database.

Highly recommended to test it on a test database first, to avoid any data loss.

Options

EntityFrameworkAuditProviderOptions:

• If the number of audits exceeds this number, the earliest audits (except Created) will be removed from the column. If null, all audits will be stored.

Output

Stored data in Audits column will be like this:

[
  {
    "f": "0",
    // Created
    "dt": "2023-09-25T12:00:00.0000000+03:30",
  },
  {
    "f": "1",
    // Updated
    "dt": "2023-09-25T12:00:00.0000000+03:30",
    "c": [
      {
        "n": "Name",
        // Name of the property
        "_v": "OldName",
        // Old value
        "v": "NewName"
        // New value
      }
    ],
    "u": {
      "id": "1",
      // The user id (if provided)
      "ad": {
        // The user additional info (if provided)
        "Username": "Foo"
      }
    }
  },
  {
    "f": "2",
    // Deleted
    "dt": "2023-09-25T12:00:00.0000000+03:30",
  },
  {
    "f": "3",
    // Restored/Undeleted
    "dt": "2023-09-25T12:00:00.0000000+03:30",
  }
]

🎆 Happy coding!