how to create a EF data model like a sql server view

I need to create a model of union of several sql server tables and i have to get ability of

insert , select , update and delete ...

(id like to use the model as same as any other model)

any suggestions ?

thanks for reading.

Edit: i tried sql server view but got the fallowing error when i want to insert to sql server view:

Msg 4406, Level 16, State 1, Line 1 Update or insert of view or function 'viewName' 开发者_运维百科failed because it contains a derived or constant field.

You need to create database view + stored procedures for insert, update and delete. You will map the view as a new entity and map imported stored procedures to insert, update and delete operations for that entity.

You actually don't need the database view - you can write the query directly to EDMX by using DefiningQuery but it requires manual modification of EDMX. Default EF tools will delete your manual modification once you run Update from database again.

Even with defining query you still need those stored procedures. There is no other way to make entity based on defining query (view is also imported as defining query) updatable.