EntityType ‘Category’ has no key defined. Define the key for this EntityType [duplicate]

by

You should add attribute [Key] before property CatId:

        using System.ComponentModel.DataAnnotations;

        public partial class Category
        {
            [Key]
            public int CatId { get; set; }
            public string CatName { get; set; }
            public string CatDescription { get; set; }
            public List<Product> Product { get; set; }
        }

The problem is that EF can work only when it knows primary key of table. By default EF recognize as primary key property with name Id. If your table has another primary key, you can mark it with attribute [Key] or set Key with fluent configuration.

More Related Contents:

  1. One DbContext per request in ASP.NET MVC (without IOC container)
  2. Why LINQ to Entities does not recognize the method ‘System.String ToString()?
  3. Multiple DB Contexts in the Same DB and Application in EF 6 and Code First Migrations
  4. using stored procedure in entity framework
  5. Should services always return DTOs, or can they also return domain models?
  6. ASP.NET MVC3 and Entity Framework Code first architecture
  7. How to change type of id in Microsoft.AspNet.Identity.EntityFramework.IdentityUser
  8. Saving Many to Many relationship data on MVC Create view
  9. Defining multiple Foreign Key for the Same table in Entity Framework Code First
  10. ‘Microsoft.SqlServer.Types’ version 10 or higher could not be found on Azure
  11. Converting flattened hierarchical data from SQL Server into a structured JSON object with C#/Linq
  12. Entity Framework Include OrderBy random generates duplicate data
  13. Use Entity framework I want to include only first children objects and not child of child(sub of sub)
  14. keyword not supported data source
  15. Model backing a DB Context has changed; Consider Code First Migrations
  16. Incompatible Data Reader Exception From EF Mapped Objects
  17. There is already an object named ‘AspNetRoles’ in the database
  18. The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value
  19. The type or namespace name ‘DbContext’ could not be found [closed]
  20. Strongly-Typed ASP.NET MVC with ADO.NET Entity Framework [closed]
  21. MVC 4 Razor File Upload
  22. Getting “A potentially dangerous Request.Path value was detected from the client (&)”
  23. How do I write unencoded Json to my View using Razor?
  24. Where is |DataDirectory| defined?
  25. ASP.NET MVC 3 client-side validation with parameters
  26. The default XML namespace of the project must be the MSBuild XML namespace
  27. DropDownListFor in EditorTemplate not selecting value
  28. Submitting form and pass data to controller method of type FileStreamResult
  29. Discovering Generic Controllers in ASP.NET Core
  30. Configure ASP.NET MVC for authentication against AD

Leave a Comment