Unable
to update the EntitySet Table because it has a DefiningQuery and no
<InsertFunction> element exists in the
<ModificationFunctionMapping> element to support the current operation
In this quick post you are going learn the way to
overcome the titled error.
HOW
TO FIX
1st
Way
Simple solution to this error is to create database
tables with primary keys.
2nd
Way
Another way is to open the .edmx file in XML Editor and
replace the <EntityContainer….> root by following code (also delete the
SQL queries) , remember to modify this code using your own Name collections.
<EntityContainer Name="MoviesAppStoreContainer">
<EntitySet Name="Movies"
EntityType="MoviesApp.Store.Movies" store:Type="Tables"
Schema="dbo" />
</EntityContainer>
These steps will fix your issue. Thanks.