Error with 1 relationship for many, Power Tools does not generate model

Question

I want to make relationship one for many in EF where one and only Territory has several regions, but when analyzing the model in Power Tools it does not recognize.

Region

[Table("Regiao")]
public class Regiao
{
    [Key]
    [DisplayFormat(DataFormatString = "{0:0000}", ApplyFormatInEditMode = true)]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public long RegiaoID { get; set; }

    [Display(Name = "Região")]
    [Column(TypeName = "varchar")]
    [StringLength(50, ErrorMessage = "O {0} deve ser de pelo menos {2} caracteres.", MinimumLength = 2)]
    [Required(ErrorMessage = "Campo Obrigatório")]
    public string RegiaoDescricao { get; set; }

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

Territory

[Table("Territorio")]
public class Territorio
{
    [Key]
    [DisplayFormat(DataFormatString = "{0:0000}", ApplyFormatInEditMode = true)]
    public long TerritorioID { get; set; }

    [Required(ErrorMessage="Campo Obrigatório")]
    public string TerritorioDescricao { get; set; }

    public ICollection<Regiao> Regioes { get; set; }
}

Context

public class DbEmpresaContext : DbContext
{
    public DbEmpresaContext()
        : base("connDBEmpresaModelo")
    {            
    }

    public DbSet<Regiao> Regioes { get; set; }
    public DbSet<Territorio> Territorios { get; set; }
}

Answer 1

I’m going to make some small changes to your code. Its entity Territory would look like this:

[Table("Territorio")]
    public class Territorio
    {
        [Key]
        [DisplayFormat(DataFormatString = "{0:0000}", ApplyFormatInEditMode = true)]
        public long TerritorioID { get; set; }

        [Required(ErrorMessage = "Campo Obrigatório")]
        public string TerritorioDescricao { get; set; }

        public virtual ICollection<Regiao> Regioes { get; set; }
    }

In this entity was added only the property virtual to accomplish the Lazy Loading (lazy loading) of Regions.

Already its entity Regio, will remain so:

[Table("Regiao")]
    public class Regiao
    {
        [Key]
        [DisplayFormat(DataFormatString = "{0:0000}", ApplyFormatInEditMode = true)]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public long RegiaoID { get; set; }

        [Display(Name = "Região")]
        [Column(TypeName = "varchar")]
        [StringLength(50, ErrorMessage = "O {0} deve ser de pelo menos {2} caracteres.", MinimumLength = 2)]
        [Required(ErrorMessage = "Campo Obrigatório")]
        public string RegiaoDescricao { get; set; }

        public long FKTerritorioID { get; set; }

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

Already in this entity, was carried out the change of the name of its foreing key for Fkterritorioid to accompany his Annotation.

Done this, just call your model again.

Template Create . EDMX with EF

To create a template just right-click on your class Context (in the above example would be the DbEmpresaContext). After that, navigate to Enitty Framework and after, View Entity Data Model, as shown in the image below.

Image source: Microsoft.

Following this example, your model will look like the image below: