AugusteVN.Modules.Auth.Database 1.0.9

AugusteVN.Modules.Auth.Database

EF Core AuthDbContext with ASP.NET Identity entities, audit tracking, and seed data for the Auth module.

DbContext

AuthDbContext

Extends IdentityDbContext<User, Role, string>. Implements IAuthDbContext.

DbSets:

• RolePermissions — DbSet<RolePermission>

Behavior:

• Uses QueryTrackingBehavior.NoTracking by default
• Automatically sets CreatedBy/CreatedAt on insert and LastModifiedBy/LastModifiedAt on update for User, Role, and AuditableEntity tracked entries
• Migrations assembly is set to the Database project; migration history table is prefixed Auth_EFMigrationHistory

Entities

• User — Extends IdentityUser, implements IAuthUser with: Name, CreatedAt, CreatedBy, LastModifiedAt, LastModifiedBy
• Role — Extends IdentityRole, implements IAuthRole with: Permissions (collection of RolePermission), Description, Type, CreatedAt, CreatedBy, LastModifiedAt, LastModifiedBy
• RolePermission — Extends AuditableEntity with: Scope (string), Sum (int bitmask), RoleId (string FK)

Interface

IAuthDbContext — Exposes RolePermissions DbSet and SaveChangesAsync via ISaveChangesAsync.

Extension Method

AddAuthDbContext(this IServiceCollection, IConfiguration) — Registers IAuthDbContext / AuthDbContext with SQL Server using the DefaultConnection connection string.

Registration

builder.Services.AddAuthDbContext(builder.Configuration);

Seed Data

The Seeder class provides ModelBuilder extension methods for initial data:

• SeedRoles — Seeds an Administrator role
• SeedRolePermissions — Grants Permissions.All on the Auth scope to the Administrator role
• SeedUsers — Seeds admin@test.com with password Test1234
• SeedUserRoles — Assigns the Administrator role to the seeded user

Migration Commands

# Create migration
dotnet ef migrations add <Name> --project ./Src/Auth/AugusteVN.Modules.Auth.Database --startup-project <YourStartupProject> --context AuthDbContext

# Apply migrations
dotnet ef database update --project ./Src/Auth/AugusteVN.Modules.Auth.Database --startup-project <YourStartupProject> --context AuthDbContext

Installation

dotnet add package AugusteVN.Modules.Auth.Database

Full Documentation

See the Auth Module README for complete documentation.

Merged Domain Documentation

AugusteVN.Modules.Auth.Database

Domain entities and shared interfaces for the Auth module — defines the contracts consumed by the EfCore persistence layer.

Contracts

IAuthUser

public interface IAuthUser : IIdentifiableEntity<string>
{
    string? Email { get; set; }
    bool EmailConfirmed { get; set; }
    string? Name { get; set; }
    string? UserName { get; set; }
    string? PhoneNumber { get; set; }
    string? PasswordHash { get; set; }
    DateTime CreatedAt { get; set; }
}

Provider-agnostic user abstraction implemented by the persistence layers.

IAuthRole

public interface IAuthRole : IIdentifiableEntity<string>
{
    string? Name { get; set; }
    string? Description { get; set; }
    string? Type { get; set; }
    DateTime CreatedAt { get; set; }
    DateTime? LastModifiedAt { get; set; }
    string? LastModifiedBy { get; set; }
    IEnumerable<RolePermission>? Permissions { get; set; }
}

IAuthDbContext

public interface IAuthDbContext
{
    Task<int> SaveChangesAsync(CancellationToken cancellationToken = default);
}

Entities

RolePermission (extends AuditableEntity)

Dependencies

• AugusteVN.Database.Entities

Installation

dotnet add package AugusteVN.Modules.Auth.Database

Full Documentation

See the Auth Module README for complete documentation.