"If your view is updatable you can simply remove the
<DefiningQuery> element from the EntitySet definition for your
view inside of the StorageModel section of your .edmx, and the normal
update processing will work as with any other table.
"
This is the case for me. Simply removing <DefiningQuery> resulted in another error. I followed the steps of this post except the last one. For your convenience, I copied the 4 steps from the post that I followed to solve the problem as following:
- Right click on the edmx file, select Open with, XML editor
- Locate the entity in the edmx:StorageModels element
- Remove the DefiningQuery entirely
- Rename the store:Schema="dbo" to Schema="dbo" (otherwise, the code will generate an error saying the name is invalid)
original answer: Here
No comments:
Post a Comment