Name: Dknet Efcore Config
Author: baoduy

スキルを検索.../

Dknet Efcore Config | Skills Pool

src/ApiEndpoints/Minimal.Infra/
├── Features/
│   └── {Feature}/
│       ├── Mappers/
│       │   └── {Entity}Configs.cs          ← Entity type configuration
│       ├── StaticData/
│       │   └── {Entity}StaticData.cs       ← Seed data (optional)
│       └── ExternalEvents/
│           └── {Event}Handler.cs           ← External event consumers (optional)
├── Services/
│   ├── {Service}.cs                         ← Domain service implementations
│   └── EventPublisher.cs                   ← DO NOT MODIFY
├── Contexts/
│   ├── CoreDbContext.cs                     ← DO NOT MODIFY
│   └── OwnedDataContext.cs                  ← Register owned types here
└── Extensions/
    ├── InfraSetup.cs                        ← DO NOT MODIFY (auto-scans)
    └── ServiceBusSetup.cs                   ← DO NOT MODIFY

using Minimal.Domains.Features.{Feature}.Entities;

namespace Minimal.Infra.Features.{Feature}.Mappers;

internal sealed class {Entity}Configs : DefaultEntityTypeConfiguration<{Entity}>
{
    #region Methods

    public override void Configure(EntityTypeBuilder<{Entity}> builder)
    {
        // MUST call base first — configures Id, CreatedBy, CreatedAt, UpdatedBy, UpdatedAt, IsDeleted
        base.Configure(builder);

        // Unique indexes
        builder.HasIndex(p => p.{UniqueField}).IsUnique();

        // Property configurations
        builder.Property(p => p.{StringProp}).HasMaxLength({max}).IsRequired();
        builder.Property(p => p.{OptionalProp}).HasMaxLength({max}).IsRequired(false);
        builder.Property(p => p.{DateProp}).HasColumnType("Date");

        // Table mapping with schema
        builder.ToTable("{TableName}", DomainSchemas.{Feature});
    }

    #endregion
}

// Inside OwnedDataContext, add to the existing ConfigureConventions or OnModelCreating:
builder.Entity<{Entity}>().OwnsOne(e => e.{OwnedProp}, owned =>
{
    owned.Property(p => p.{Prop}).HasMaxLength({max});
});

using DKNet.EfCore.Extensions.DataSeeding;
using Minimal.Domains.Features.{Feature}.Entities;

namespace Minimal.Infra.Features.{Feature}.StaticData;

internal sealed class {Entity}StaticData : SqlDataSeeding<{Entity}>
{
    protected override IEnumerable<{Entity}> Data =>
    [
        new({params for seed row 1}),
        new({params for seed row 2}),
    ];
}

using Minimal.Domains.Services;

namespace Minimal.Infra.Services;

/// <summary>
/// Implementation of <see cref="I{Service}"/>.
/// </summary>
internal sealed class {Service} : I{Service}
{
    private readonly ISequenceServices _sequence;

    public {Service}(ISequenceServices sequence)
    {
        _sequence = sequence;
    }

    public async Task<string> NextValueAsync()
    {
        var seq = await _sequence.NextValueAsync(Sequences.{Entity}Seq);
        return $"{PREFIX}-{seq:D6}";
    }
}

cd src/ApiEndpoints
./add-migration.sh {MigrationName}

internal sealed class CustomerProfileConfigs : DefaultEntityTypeConfiguration<CustomerProfile>
{
    public override void Configure(EntityTypeBuilder<CustomerProfile> builder)
    {
        base.Configure(builder);

        builder.HasIndex(p => p.Email).IsUnique();
        builder.HasIndex(p => p.MembershipNo).IsUnique();
        builder.Property(p => p.Avatar).HasMaxLength(50);
        builder.Property(p => p.BirthDay).HasColumnType("Date");
        builder.Property(p => p.Email).HasMaxLength(150).IsRequired();
        builder.Property(p => p.MembershipNo).HasMaxLength(50).IsRequired();
        builder.Property(p => p.Name).HasMaxLength(150).IsRequired();
        builder.Property(p => p.Phone).HasMaxLength(50).IsRequired(false);
        builder.ToTable("CustomerProfiles", DomainSchemas.Profile);
    }
}

internal sealed class MembershipService(ISequenceServices sequence) : IMembershipService
{
    public async Task<string> NextValueAsync()
    {
        var seq = await sequence.NextValueAsync(Sequences.MembershipSeq);
        return $"MEM-{seq:D6}";
    }
}

Mistake	Fix
Inheriting `IEntityTypeConfiguration` directly	Use `DefaultEntityTypeConfiguration<T>` — it configures audit fields
Forgetting `base.Configure(builder)`	Must be first line — sets up Id, audit trail, IsDeleted filter
Making mapper `public`	Must be `internal sealed` for Scrutor auto-discovery
Placing mapper outside `Mappers/` folder	Scrutor scans by namespace — must be in correct folder
Missing `HasMaxLength` on strings	SQL Server defaults to `nvarchar(max)` — always constrain
Service not `sealed` or wrong namespace	Must be `sealed` + in `.Services` or `.Repos` namespace

Dknet Efcore Config

Skill: EF Core Configuration

When to Use

Inputs Required

Dknet Efcore Config

Skill: EF Core Configuration

When to Use

Inputs Required

Project Conventions (from actual codebase)

Mapper Pattern

File Locations

Auto-Discovery Rules (Scrutor)

Step-by-Step

Step 1: Create the Mapper Class

Step 2: Configure Owned Types (if entity has value objects)

Step 3: Add Static Seed Data (optional)

Step 4: Implement Domain Service (if interface exists)

Step 5: Run Migration

Reference: CustomerProfile (actual production code)

Mapper

Service Implementation

Validation Checklist

Common Mistakes

Next Steps

Sherlock

Domain Name Brainstormer

Bmad Domain Research

Claimable Postgres

Active Directory Attacks

Gws Gmail Watch