Updatable Views in Entity Framework 5/6

I would think that your easiest method, would be to change the definition of your EntitySet in your StorageModel to tell it to regard it as a table, as opposed to a database-view.

Looking at the XML definition, where it says

<EntitySet Name="Products" store:Type="Views" ..

you change that to

<EntitySet Name="Products" store:Type="Tables" ..

(Note the “Products” is just an example)
This should be in your .edmx file.
See pg 44, Lerman, “Programming Entity Framework”, 2nd Ed.

Hope this helps.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)