Error 6002: The table/view does not have a primary key defined

by

I perfectly understand where you’re coming from. This is one of the biggest annoyances I’ve had to deal with when trying to get to grips with the EF and, apparently, it’s a very common issue.

The solution that worked for me was to open the EDMX with the view in designer mode and assign a primary key myself. It doesn’t matter really what it is, as long as there is one. You right-click on the column you want to set as primary key and select Entity Key (it’s a checkbox option). You may have to exit and restart Visual Studio until this warning decides to go away.

I hope it works for you too. But even if it does, it’s a short-term fix, as the next time you update your view, it will probably have the same problem. But as long as the above steps work, it should take just seconds to fix.

Also, here’s some links you might find useful:

More Related Contents:

  1. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  2. Code First: Independent associations vs. Foreign key associations?
  3. Unique Key constraints for multiple columns in Entity Framework
  4. Entity Framework 6 Code first Default value
  5. Database first create entity framework 6.1.1 model using system.data.sqlite 1.0.93
  6. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  7. How to configure ProviderManifestToken for EF Code First
  8. “like” queries in Entity Framework
  9. Querying objects after AddObject before SaveChanges?
  10. Entity Framework 4.1 default eager loading
  11. PropertyGrid Browsable not found for entity framework created property, how to find it?
  12. Entity framework PostgreSQL
  13. Loop/reflect through all properties in all EF Models to set Column Type
  14. EF can’t infer return schema from Stored Procedure selecting from a #temp table
  15. MetadataException when using Entity Framework Entity Connection [duplicate]
  16. Using Entity Framework with an SQL Compact Private Installation
  17. Entity Framework Data Annotations Set StringLength VarChar
  18. EF 4.1 loading filtered child collections not working for many-to-many
  19. How to map Table per Type (TPT) inheritance in Entity designer?
  20. EF Code First foreign key without navigation property
  21. Nullable property to entity field, Entity Framework through Code First
  22. LINQ to Entities for subtracting 2 dates
  23. Entity Framework Code First Using Guid as Identity with another Identity Column
  24. AutomaticMigrationsEnabled false or true?
  25. ADO.NET Entity Framework tutorials [closed]
  26. Entity Framework Code First Many to Many Setup For Existing Tables
  27. Compose queries across Entity Data Models
  28. Changing Inherited Types in Entity Framework
  29. Why is my Entity Framework Code First proxy collection null and why can’t I set it?
  30. Why does the entity framework need an ICollection for lazy loading?

Leave a Comment