Entity Framework Coreでマルチテナントを安全に論理分割する方法

  web-db:
    image: postgres:14
    container_name: web_db
    environment:
      POSTGRES_USER: tasuki
      POSTGRES_PASSWORD: tasuki
      POSTGRES_DB: tasuki
    ports:
      - "5432:5432"

public partial class Company
{
    public long CompanyId { get; set; }
    public string CompanyName { get; set; }
    public virtual ICollection<User> Users { get; set; } = new List<CustomerUser>();
    public virtual ICollection<Project> Projects { get; set; } = new List<ProjectInfo>();
}

public partial class Project
{
    public string ProjectId { get; set; }
    public long UserId { get; set; }
    public string ProjectName { get; set; }
    public long CompanyId { get; set; }
    public virtual Company Company { get; set; }
    public virtual User User { get; set; }
    public virtual ICollection<ProjectMember> ProjectMembers { get; set; } = new List<ProjectMember>();
}

public partial class Member
{
    public string MemberId { get; set; }
    public string ProjectId { get; set; }
    public long UserId { get; set; }
    public virtual User User { get; set; }
    public virtual Project Project { get; set; }
}

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 {
      base.OnModelCreating(modelBuilder);
）
      // テナントでフィルタ
      modelBuilder.Entity<Company>().HasQueryFilter(x => EF.Property<long>(x, "CompanyId") == _companyId);

      // アサインプロジェクトでフィルタ
      modelBuilder.Entity<Project>().HasQueryFilter(x => x.Members.Any(y => EF.Property<long>(y, "UserId") == _userId));
}