Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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?

like image 510
Adam Gordon Bell Avatar asked Aug 29 '10 17:08

Adam Gordon Bell


1 Answers

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

like image 152
Adam Gordon Bell Avatar answered Oct 16 '22 19:10

Adam Gordon Bell