I can't add a controller in mvc 4 code first

Question

I cant add a controller, it says:

Unable to retrieve Metadata for "Diets.Models.Usuario" The Property "ProgramaDietaID" cannot be configurated as Navigation Property. The property must be a valid Entity and the property should have a non-abstract getter and setter. For collection Properties the type must implement ICollection where T is a valid entity type.

I don't figure out what I'm doing wrong, the roles between "Usuario" and "ProgramaDieta" entities are one-to-many.

public class Usuario
{
    [Key]
    [Required]
    public int UsuarioID { get; set; } 

    [Display(Name = "Name:")]//lo que mostrara el titulo del campo la Vista.
    [StringLength(50, ErrorMessage = "The name cannot be longer than 50 characters.")]
    [RegularExpression(@"^[a-zA-Z''-'\s]*$")]//para que acepte solo letras y no carac. alfanumericos.
    [Required]
    public string Nombre { get; set; }
    public virtual ICollection<ProgramaDieta> ProgramaDietas { get; set; }
}

public class ProgramaDieta
{
   [Key]
   public int ProgramaDietaID { get; set; }

   [ForeignKey("UsuarioID")]
   public int UsuarioID { get; set; }
   public virtual Usuario Usuario { get; set; }
}

Context Class

public class MejoraConProgramasContext:DbContext
{
    public MejoraConProgramasContext()
        : base("MejoraConProgramasContext")
    {
    }

    public DbSet<Usuario> Usuarios { get; set; }
    public DbSet<ProgramaDieta> Programas { get; set; }
}

Wiktor Zychla · Accepted Answer · 2013-12-08 20:07:02Z

1

The ForeignKey is improperly attached to the int UsuarioID property instead of the virtual Usuario Usuario.

answered Dec 8, 2013 at 20:07

Wiktor Zychla

48.5k6 gold badges83 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Gert Arnold Over a year ago

Hehe, nice catch. I kept staring at this.

Wiktor Zychla Over a year ago

I was staring for some time, too :)

Roberto Massimo Patara Brianco Over a year ago

Thanks for the try, but the problem keeps, after delete Foreign key form UsuarioID and put in Usuario Usuario :(, I believe is a mapping entities problem.

Collectives™ on Stack Overflow

I can't add a controller in mvc 4 code first

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related