I'm using EF in my application.
I try to save\insert a new record to a mapping table
and get the following error:
Unable to update the EntitySet 'UsersLimitationToCountry' because it has a DefiningQuery and no <InsertFunction> element exists in the <ModificationFunctionMapping> element to support the current operation.
Should I define it in the edmx myself? How?
My many-to-many mapping table was missing PK
added, and the issue is solved.
Agreed with the accepted answer. Just providing the reason behind it...
When EF mapping is done with a table which does not have a primary key, it is treated as a view. Since views are logical entities, they can't be updated.
So either add the missing primary key to your table or consider them as a view & don't perform any update operation on them.