Entity Framework 4 - View / Insert Views

Question

My EF schema has a mixture of tables and views from my database. My view objects are all read-only, I want to be able to update / insert these objects. I tried the following record with no luck:

http://smehrozalam.wordpress.com/2009/08/12/entity-framework-creating-a-model-using-views-instead-of-tables/

Anyone have other ideas / pointers - this should be doable.

amuses David

Answer 1

Usually the message is correct. Using representations in EF is complicated. Another trick is to first use tables to determine your model, and then replace the tables in the database with views with the same names as the tables.

Answer 2

Did you try instead of triggers?

http://www.codeproject.com/Articles/236425/How-to-insert-data-using-SQL-Views-created-using-m