Entity Framework 6 error: Unable to update the EntitySet 'table1'

Question

full error is:

Unable to update the EntitySet 'table1' because it has a DefiningQuery and no <InsertFunction> element exists in the <ModificationFunctionMapping> element to support the current operation

From looking around, it seems this error is caused by a lack of a primary key on table1. I have checked my .edmx file and the table in SQL server and both show that a primary key is specified. What else should I be looking at?

how about showing some code? should probably look on social.msdn.microsoft.com/Forums/en-US/… — Miller
– Miller, Commented Feb 17, 2014 at 20:08

Pawel · Accepted Answer · 2014-02-18 00:11:43Z

1

If you are using edmx the DefiningQuery will be defined for database views and EF will treat an EntitySet created from view as read-only. If you want to be able to manipulate your data you will need to map stored procedures which will be used for CUD (Create/Update/Delete) operations.

answered Feb 18, 2014 at 0:11

Pawel

31.7k4 gold badges76 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework 6 error: Unable to update the EntitySet 'table1'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related