entity framework

Unable to update the EntitySet 'table' because it has DefiningQuery and no DeleteFunction element exists in the ModificationFunctionMapping

Unable to update the EntitySet 'table' because it has DefiningQuery and no DeleteFunction element exists in the ModificationFunctionMapping , someone asked me to explain?

In this tutorial i will show how to solve the error "Unable to update the EntitySet because it has a DefiningQuery and no element exists in the element to support the current operation". What exactly i got is,

Unable to update the EntitySet 'table' because it has DefiningQuery "

Unable to update the EntitySet 'table' because it has DefiningQuery and no DeleteFunction element exists in the ModificationFunctionMapping element to support the current Opereation" This error i was getting while updating the record to the table. Finally i understood it is due to the primary key was removed. After enable the primary key and update the entity .edmx file it works properly. Then also if it is not worked next delete the entity model and create model. Build the project and run. Here I checked It works as expected.

Video explaination below

Post your comments / questions