mws.backend.dotnet/infrastructure/Persistence/Configuration/ProjectMemberConfiguration.cs

using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;
using mws.backend.dotnet.domain.Projects;

namespace mws.backend.dotnet.infrastructure.Persistence.Configuration;

public class ProjectMemberConfiguration : IEntityTypeConfiguration<ProjectMember>
{
    public void Configure(EntityTypeBuilder<ProjectMember> e)
    {
        e.ToTable("project_members");
        e.HasKey(m => new { m.ProjectId, m.UserId });
        e.Property(m => m.Role).HasConversion<string>().HasMaxLength(20);

        e.HasOne(m => m.Project)
            .WithMany(p => p.Members)
            .HasForeignKey(m => m.ProjectId)
            .OnDelete(DeleteBehavior.Cascade);

        e.HasOne(m => m.User)
            .WithMany()
            .HasForeignKey(m => m.UserId)
            .OnDelete(DeleteBehavior.Cascade);
    }
}