EF Core Relationships one-to-Many-to-Many Fluentapi

Question

Good afternoon, I’d like to take a relationship question from Entity Core. I have a table person and the person has a position (Manager, supervisor, responsible, etc..)

public class Pessoa
{
    public int PessoaId { get; set; }
    public string Nome { get; set; }
    public int CargoId { get; set; }
    public virtual Cargo { get; set; }
}

public class Cargo
{
    public int CargoId { get; set; }
    public string Nome { get; set; }
    public virtual ICollection Pessoas { get; private set; }
}

So far I have no doubt.

Now let’s assume that I have a Room table and this room has a Manager, a Supervisor and a Guardian, who are People. How would the relationship look ?

Thus:

public class Sala
{
    public int SalaId { get; set; }
    public string Nome { get; set; }
    public int ResponsavelId { get; set; }
    public virtual Pessoa Responsavel {get; set; }
    public int SupervisorId { get; set; }
    public virtual Pessoa Supervisor {get; set; }
    public int GerenteId { get; set; }
    public virtual Pessoa Gerente {get; set; }

}

And would alter Pessoa

public class Pessoa
{
    public int PessoaId { get; set; }
    public string Nome { get; set; }
    public int CargoId { get; set; }
    public virtual Cargo { get; set; }

    public virtual ICollection Salas { get; private set; }
}

And would create the relationship in of each field in the Fluent API with the Rooms property or

public class Pessoa
{
    public int PessoaId { get; set; }
    public string Nome { get; set; }
    public int CargoId { get; set; }
    public virtual Cargo { get; set; }

    public virtual ICollection SalaResponsavel { get; private set; }
    public virtual ICollection SalaSupervisor { get; private set; }
    public virtual ICollection SalaGerente { get; private set; }
}

Answer 1

This way you’re doing it, it would look like this:

 public virtual Sala SalaResponsavel { get; private set; }
 public virtual Sala SalaSupervisor { get; private set; }
 public virtual Sala SalaGerente { get; private set; }

But I think it gets a little messy, I think I’d make another table containing

Sala
Pessoa
Cargo

So the relationship would be n-n

I’m by cell phone now, the night I try to complement more the answer

Answer 2

For my context the answer of the link below was the solution.

https://stackoverflow.com/questions/42745465/ef-core-many-to-many-relationship-on-a-class

I mapped and the entity uploaded without problem. Now Dapper fills in the data. Thank you.