Hasim.EntityFrameworkCore 0.1.1

Hasim.EntityFrameworkCore

A customizable ASP.NET Core Identity entities library providing reusable base identity models and common abstractions for modern .NET applications.

Built on top of Entity Framework Core, this library ships an audit-enabled DbContext (derived from IdentityDbContext), ready-to-use entity type configurations, and a dependency-injection module so you can wire up SQL Server + Identity + audit logging in a few lines.

✨ Features

• Identity-ready DbContext — AuditIdentityContext extends IdentityDbContext with int-keyed identity types (AppUser, AppRole, claims, roles, logins, tokens).
• Audit logging out of the box — built-in AuditLog and EntityChange entities to track who did what, when.
• EF Core configurations — table mappings, indexes, and relationships are defined via IEntityTypeConfiguration<T> implementations and applied automatically.
• Pluggable DI module — an Injectify-based EntityFrameworkCoreModule registers the context with the SQL Server provider and the audit interceptor.
• Packaged as a NuGet library — drop it into any ASP.NET Core app.

📦 Installation

dotnet add package Hasim.EntityFrameworkCore

🚀 Getting Started

1. Configure the connection string

Add a DefaultConnection connection string to your appsettings.json:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Database=YourDb;Trusted_Connection=True;TrustServerCertificate=True;MultipleActiveResultSets=true"
  }
}

2. Register the module

Register the EntityFrameworkCoreModule through your DI container (Injectify). The module:

• Adds AuditIdentityContext to the service collection.
• Configures it to use the SQL Server provider and the DefaultConnection connection string.
• Attaches the PersistingAuditInterceptor (from Hasim.Auditify) to persist audit entries automatically.

3. Use the context

Resolve AuditIdentityContext (or inject it into your services) and work with the exposed DbSets:

using Hasim.EntityFrameworkCore.Persistence;
using Microsoft.EntityFrameworkCore;

// Inside your service
public class MyService(AuditIdentityContext db)
{
    public async Task DoSomethingAsync(CancellationToken ct = default)
    {
        // e.g. query audit logs
        var logs = await db.AuditLogs
            .Include(a => a.EntityChanges)
            .ToListAsync(ct);
    }
}

🧱 Architecture

Hasim.EntityFrameworkCore/
├── Configurations/
│   ├── AuditLogConfiguration.cs        # AuditLog table mapping, indexes, relationships
│   ├── EntityChangeConfiguration.cs    # EntityChange table mapping
│   └── UserConfiguration.cs            # AppUser table mapping
├── Module/
│   └── EntityFrameworkCoreModule.cs    # Injectify DI module (SQL Server + audit interceptor)
└── Persistence/
    └── AuditIdentityContext.cs         # IdentityDbContext + AuditLogs / EntityChanges DbSets

Entities

Database mappings

• Tables: AuditLog, EntityChange, User.
• AuditLog has indexes on Timestamp and UserId, a Restrict delete relationship to the user, and a Cascade delete relationship to its EntityChanges.
• Configurations are applied automatically via ApplyConfigurationsFromAssembly.

📚 Dependencies

• Hasim.Auditify — audit interceptor
• Hasim.Core — base entities
• Hasim.Injectify — DI module system
• Microsoft.AspNetCore.Identity.EntityFrameworkCore 8.x
• Microsoft.EntityFrameworkCore.SqlServer 8.x
• Microsoft.EntityFrameworkCore.Relational 8.x

🔧 Requirements

• .NET 8.0 SDK

🤝 Contributing

1. Fork the repository.
2. Create a feature branch.
3. Submit a pull request.

📄 License

This project is licensed under the MIT License.