How To Fix "Unable to update the entityset because it has a defining query and no UpdateFunction element exists in the ModificationFunctionMapping element to support the current operation" Error



TODO:

You try to insert a record using the Entity Framework and get the following error:

"Unable to update the entityset because it has a defining query and no <UpdateFunction> element exists in the <ModificationFunctionMapping> element to support the current operation"

 

SOLUTION:

Add a primary key to the table.  Also make sure the Concurrency Mode of the Primary Key is set to "Fixed" (right click column, choose properties)

 

NOTES:

There are no notes on this topic.