How map objects to a view with EF 4 code first?

.net entity-framework entity-framework-4 ef4-code-only
Adam Gordon Bell picture Adam Gordon Bell · Aug 29, 2010 · Viewed 20.3k times · Source

How can you map an entity to a database view with EF 4 code first?

Is there a way to do this by deriving from the EntityConfiguration classes?

Answer

Adam Gordon Bell picture Adam Gordon Bell · Aug 30, 2010

Yes! I found the answer:

You can certainly use Code First to map to a view, just tell Code First that it's a table and it will use the same SQL against the view that it would for a table. Obviously if your view isn't writeable then saving is going to fail if you try and update values in the entities that are based on the view, but we will just delegate to the database so if you don't update these entities then you won't have any issues.

http://social.msdn.microsoft.com/Forums/en-US/adonetefx/thread/f154595c-717e-4703-a81d-ee63633a481e

Related questions

How not persist property EF4 code first?

How do I make non persisted properties using codefirst EF4? MS says there is a StoreIgnore Attribute, but I cannot find it. http://blogs.msdn.com/b/efdesign/archive/2010/03/30/data-annotations-in-the-entity-framework-and-code-first.aspx Is there a way to set this up using …

Read More
Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths - why?

I've been wrestling with this for a while and can't quite figure out what's happening. I have a Card entity which contains Sides (usually 2) - and both Cards and Sides have a Stage. I'm using EF Codefirst migrations and the …

Read More
Why am I getting this error: No mapping specified for the following EntitySet/AssociationSet - Entity1?

I'm using Entity Framework 4 with the Model First approach. I started the project, designed the entities and generated the database. Everything worked fine. Then I needed to go back and add another entity to my model. However, as I drag …

Read More