Relationship Problem with EF6 (Relationship and Associative Class)

Question

I need to know if my auto relationship and my associative class are created correctly according to the original model made in the SQL Server Diagram.

Original Model - SQL Server

My model in Power Tools

Classe Região

[Table("Regiao")]
public class Regiao
{
    [Key]
    public long RegiaoID { get; set; }
    public string RegiaoDescricao { get; set; }
    public virtual ICollection<Territorio> Territorios { get; set; }
}

Class Territory

[Table("Territorio")]
public class Territorio
{
    [Key]
    public long TerritorioID { get; set; }
    public string TerritorioDescricao { get; set; }

    public long RegiaoID { get; set; }

    [ForeignKey("RegiaoID")]
    public virtual Regiao Regiao { get; set; }
    public virtual ICollection<TerritorioEmpregado> TerritorioEmpregados { get; set; }

}

Employee class

[Table("Empregado")]
public class Empregado
{
    [Key]
    public long EmpregadoID { get; set; }
    public string PrimeiroNome { get; set; }
    public string UltimoNome { get; set; }
    public string Titulo { get; set; }
    public string TituloDeCortesia { get; set; }
    public DateTime DataNascimento { get; set; }
    public DateTime DataContratacao { get; set; }
    public string Endereco { get; set; }
    public string Cidade { get; set; }
    public string Regiao { get; set; }
    public string CodigoPostal { get; set; }
    public string Pais { get; set; }
    public string TelefoneResidencial { get; set; }
    public string Extensao { get; set; }
    public string Notas { get; set; }

    public virtual ICollection<TerritorioEmpregado> TerritorioEmpregados { get; set; }

    public virtual Empregado Empregado1 { get; set; }
}

Class Associative Territorioemployed

public class TerritorioEmpregado
{
    [Key]
    public long TerritorioEmpregadoID { get; set; }
    public long TerritorioID { get; set; }

    [ForeignKey("TerritorioID")]
    public virtual Territorio Territorio { get; set; }

    public long EmpregadoID { get; set; }

    [ForeignKey("EmpregadoID")]
    public virtual Empregado Empregado2 { get; set; }
}

Answer 1

If your intention is to use an associative table, you must create it and carry out the appropriate associations.

In this case, you would need to create the entity Territories. As your model SQL Show, she will be the link between Territories and Employees.

That entity would look like this:

 public class TerritorioEmpregado
    {
        [Key]
        public int TerriTorioEmpregadoId { get; set; }

        public int TerritorioId { get; set; }
        public int EmpregadoId { get; set; }

        public virtual Territorio Territorio { get; set; }
        public virtual Empregado Empregado { get; set; }
    }

Remember that this is just an example. You can change it in the way that best suits you. But it should be in your code.

Once done, you will already have the association you want. However, your entity Employee has this association:

 public long TerritorioID { get; set; }

    [ForeignKey("TerritorioID")]
    public virtual Territorio Territorio { get; set; }
    public virtual ICollection<Empregado> Empregados1 { get; set; }
    public virtual Empregado Empregados2 { get; set; }
    public virtual ICollection<Territorio> Territorios { get; set; }

That would be unnecessary. In this part you are saying that your employee has 1 territory, 1 employee, a list of Territories and a list of employees. I don’t think that’s what you want.

Change to that:

 public virtual ICollection<TerritorioEmpregado> TerritorioEmpregado { get; set; }
 public virtual Empregado Empregados2 { get; set; }

In this case, you’re saying that an employee has a list of Territoriumemployed and a relationship with himself.

Doing this, your model will look like this: