.NET Entity Framework Unable to update the EntitySet because it has a DefiningQuery and no element exists in the element to support the current operation
Error: Unable to update the EntitySet because it has a DefiningQuery and no
element exists in the
element to support the current operation
The error may occur because there is no Primary Key defined in the
table being referenced.
First, make a column a primary key:
alter table myTable
Add primary key (myColumnChoice)
Second, delete the table and re add it to your project (or EDMX file).
That should do it.
See also