In general our recommendation is to use mapped views only for read-only operations. Allowing Create
operations over a view is tricky as behavior largely depends on the view definition.
The issue that is preventing you from getting your Update procedure in the DDL
scripts is cause by two facts:
1. Telerik Data Access Runtime does not support CUD
operations for Views
2. Visual Designer does not distinguish between tables and views so it allows you to apply an unsupported feature to your view.
Please excuse us for the confusion.
I would suggest two different approaches to work around this limitation
1. Use the view as read-only data source and persist any changes via dedicated persistent types bound to tables.
2. Create the required stored procedure manually and add it to your model from the database. Call it manually whenever you want to modify a record in the view. Do not forget to commit the transaction for the procedure call by calling context.SaveChanges()
If you need any further assistance, please let us know.
Telerik by Progress
Check out the latest announcement
about Telerik Data Access vNext as a powerful framework
able to solve core development problems.