Cannot create controller with Entity framework - Unable to retrieve metadata

Question

I'm using VS2013

When I try to create an "MVC 5 Controller with views using entity Framework" I get the following error:

there was an error running the selected code generator ''Unable to retrieve metadata for WebApplication.Domain.Entities.Product'.'

EFDbContext.cs

using System.Data.Entity;
using WebApplication.Domain.Entities;

namespace WebApplication.Domain.Concrete
{
    public class EFDbContext : DbContext
    {
        public DbSet Products;
    }
}

Product.cs

using System.ComponentModel.DataAnnotations;

namespace WebApplication.Domain.Entities
{
    public class Product
    {
        [Key]
        public int ProductID { get; set; }

        [Required]
        public string Title { get; set; }
    }
}

Web.config

I have a Table set up called Products and it has a definition like so:

CREATE TABLE [dbo].[Products] (
    [ProductID] INT            IDENTITY (1, 1) NOT NULL,
    [Title]     NVARCHAR (255) NULL,
    PRIMARY KEY CLUSTERED ([ProductID] ASC)
);

Any ideas what is going wrong? I have tried everything that has returned on Google.

Packages I have installed:

My project can be found here: https://github.com/jimmyt1988/WebApplication2

user_6737444 · Answer

Please check all the Models are registered in context

Example:

You have a Model like this

public class MedicineStrength
{
    [Key]
    public int Id { get; set; }
    public int? MedicineId { get; set; }
    [ForeignKey("MedicineId")]
    public Medicine Medicine { get; set; }

    public double Strength { get; set; }

    public int? MetricPrefixId { get; set; }
    [ForeignKey("MetricPrefixId")]
    public virtual MetricPrefix MetricPrefix { get; set; }

    public int? UnitId { get; set; }
    [ForeignKey("UnitId")]
    public virtual Unit Unit { get; set; }

    public int? MedicineTypeId { get; set; }
    [ForeignKey("MedicineTypeId")]
    public virtual MedicineType MedicineType { get; set; }
}

Check all virtual Model instances are registered in in context like this

public class HMContext : DbContext
    {
        public HMContext()
        : base("name=HMContext")
        {
            Database.SetInitializer(null);
        }

        /// ... ///

        public virtual DbSet Medicines { get; set; }
        public virtual DbSet MedicineGenerics { get; set; }
        public virtual DbSet MedicineStrengths { get; set; }
        public virtual DbSet MedicineTypes { get; set; }
        public virtual DbSet MedicineDosages { get; set; }
        public virtual DbSet MedicineCategories { get; set; }
        public virtual DbSet MetricPrefixes { get; set; }
        public virtual DbSet Units { get; set; }

        ///...///
    }

user_8815762 · Answer

If you trying to create a Odata controller

Go to DbContext class and then check whether

public System.Data.Entity.DbSet YourModel{ get; set; }

Available ior not

If yes .. remove it and then retry

user_2275336 · Answer

For me, I have to "run custom tool" by right click on model.tt and model.context.tt files, then error got resolved.

Cannot create controller with Entity framework - Unable to retrieve metadata

7 Answers