How do I define a database view using Entity Framework 4 Code-First?

by

That’s because you cannot define database view using code-first approach. Database view is database construct which uses SQL Query on top of existing tables / functions. You can’t define such constructs using code first.

If you want view you must create it manually by executing CREATE VIEW SQL script for example in custom initializer – it will be similar like this answer. Just be aware that this will not help you if you want to map entity to a view. In such case you would probably have to first drop table created by EF and create view with the same name (I didn’t try it but it could do the trick). Also be aware that not every view is udpatable so you will most probably get read only entity.

More Related Contents:

  1. Composite Key with EF 4.1 Code First
  2. Unique key with EF code first
  3. What effect(s) can the virtual keyword have in Entity Framework 4.1 POCO Code First?
  4. EntityType ‘IdentityUserLogin’ has no key defined. Define the key for this EntityType
  5. Ignoring a class property in Entity Framework 4.1 Code First
  6. One DbContext per request in ASP.NET MVC (without IOC container)
  7. How Should I Declare Foreign Key Relationships Using Code First Entity Framework (4.1) in MVC3?
  8. How to delete and recreate from scratch an existing EF Code First database
  9. Entity Framework code first. Find primary key
  10. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  11. How do I detach objects in Entity Framework Code First?
  12. Overriding SaveChanges and setting ModifiedDate, but how do I set ModifiedBy?
  13. EF Code First – how to set identity seed?
  14. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  15. Entity framework code-first null foreign key
  16. Using mvc-mini-profiler database profiling with Entity Framework Code First
  17. How to configure many to many relationship using entity framework fluent API
  18. How to map table splitting in EF Code First?
  19. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  20. Navigation Property without Declaring Foreign Key
  21. How I can read EF DbContext metadata programmatically?
  22. An error occurred while saving entities that do not expose foreign key properties for their relationships
  23. Entity Framework Database.SetInitializer simply not working
  24. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  25. Enums with EF code-first – standard method to seeding DB and then using?
  26. Convert DBContext to ObjectContext for use with GridView
  27. Set database collation in Entity Framework Code-First Initializer
  28. Model First with DbContext, Fails to initialize new DataBase
  29. Map Many to Many relationship without navigation property
  30. Getting exact error type in from DbValidationException

Leave a Comment