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

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:

• SO: Entity Framework and SQL Server View
• SO: cannot add view to the edmx
• ASP.NET forum: Entity model from table views.

In my case this has solved easily, below are steps:

• Clean up the solution
• Close Visual Studio
• Open Visual Studio
• Clean up and Build the solution

Before trying anything, this can be tried to make sure you are not changing anything manually in edmx.

I hope this will help.

I have had luck in EF4 and EF5 using the technique described by http://www.hilmiaric.com/?p=95 using rownumber as the ID

SELECT ISNULL((ROW_NUMBER() OVER (ORDER BY XXX ASC)), 0) AS 'ID',

But I don't have a solution for EF5 and above. Last tried on 6.1.3