开发者

Define the key for this EntityType

I get this error on this line of code -

    ReportRunnerEntities reportDB = new ReportRunnerEntities();

    public ActionResult Index()
    {
        **var types = reportDB.ReportTypes.ToList();**
        return View(types);
    }

The tables in开发者_运维技巧 the databse have primary keys defined and identities set.

My models are -

namespace ReportRunner.Models
{
    public partial class ReportRunnerEntities : DbContext
    {
        public DbSet<Reports> Report { get; set; }
        public DbSet<ReportTypes> ReportTypes { get; set; }
        public DbSet<Users> Users { get; set; }
    }
}

namespace ReportRunner.Models
{
    public partial class ReportTypes
    {
        public int ReportTypeId { get; set; }
        public string Name { get; set; }
        public string Description { get; set; }
        public List<Reports> Reports { get; set; }
    }
}

namespace ReportRunner.Models
{
    public class Reports
    {
        public int ReportId { get; set; } 
        public int ReportTypeId { get; set; }
        public int UserId { get; set; } 
        public string Title { get; set; }
        public ReportTypes ReportType { get; set; }
    }

}

namespace ReportRunner.Models
{
    public partial class Users
    {
        public int UserId { get; set; } //ArtistId
        public string Name { get; set; }
    }
}

and here is my connection string -

I suspect that it's never reaching the database. As I said the keys are set in the database.

Am I missing something?


There are a couple things I see that should change:

  • ReportTypes should be ReportType

  • public List Reports { get; set; } should be public ICollection Reports { get; set; }

  • If you are defining a connection string in your web.config, you need to tell EF what one it is using the constructor in your ReportRunnerEntities class like this:


    namespace ReportRunner.Models
    {
        public partial class ReportRunnerEntities : DbContext
        {
            public ReportRunnerEntities : base("name=NameOfConnectionInWebConfig")
            {}
            public DbSet<Reports> Report { get; set; }
            public DbSet<ReportTypes> ReportTypes { get; set; }
            public DbSet<Users> Users { get; set; }
        }
    }
    

You can read more on that here : http://blogs.msdn.com/b/adonet/archive/2011/01/27/using-dbcontext-in-ef-feature-ctp5-part-2-connections-and-models.aspx

Just on a side note, if you are planning on using .NET MVC and EF Code First as your stack, I would start using the Repository and Unit of Work pattern. Here is a good post on how to set that up: Entity Framework 4 CTP 4 / CTP 5 Generic Repository Pattern and Unit Testable

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜