Mapping Database Views to EF 5.0 Code First w/Migrations

by

You have specified that the ClientStatisticsView entity should be mapped to a table named “ClientStatistics”. So entity framework will generate a migration containing an instruction to create that table. But you have independently created that view in the database so to prevent the error you are getting you should remove the CreateTable instruction from the Up migration.

I think a better way to do it is to create the view in the migration by running sql like this:

public override void Up()
{
    Sql("EXEC ('CREATE View [dbo].[ClientStatistics] AS --etc"
}

public override void Down()
{

    Sql(@"IF  EXISTS (SELECT
                        *
                    FROM sys.views
                    WHERE object_id = OBJECT_ID(N'dbo.ClientStatistics'))
                    DROP VIEW dbo.ClientStatistics)")
}

That way your views and tables are specified in one place and you can safely migrate up and down

Reference

http://elegantcode.com/2012/04/12/entity-framework-migrations-tips/

More Related Contents:

  1. Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship
  2. EF migration for changing data type of columns
  3. EF5 Code First – Changing A Column Type With Migrations
  4. Ignoring a class property in Entity Framework 4.1 Code First
  5. Entity Framework Join 3 Tables
  6. The entity type is not part of the model for the current context
  7. EF Including Other Entities (Generic Repository pattern)
  8. EF Code First: How to get random rows
  9. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  10. Non-static method requires a target
  11. Creating Composite Key Entity Framework
  12. Debug code-first Entity Framework migration codes
  13. Entity Framework Code First Lazy Loading
  14. Calculated column in EF Code First
  15. Enable Migrations with Context in Separate Assembly?
  16. Can EF automatically delete data that is orphaned, where the parent is not deleted?
  17. Optimistic concurrency: IsConcurrencyToken and RowVersion
  18. get date part only from datetime value using entity framework
  19. EF4 Code First: how to add a relationship without adding a navigation property
  20. How do I specify that a property should generate a TEXT column rather than an nvarchar(4000)
  21. How to Specify Primary Key Name in EF-Code-First
  22. Entity Framework: Duplicate Records in Many-to-Many relationship
  23. Mixing Fluent API and DataAnnotations in EF code first
  24. Entity Framework Code First naming conventions – back to plural table names?
  25. Entity Framework Code First Using Guid as Identity with another Identity Column
  26. The relationship could not be changed because one or more of the foreign-key properties is non nullable
  27. How should I set up my integration tests to use a test database with Entity Framework?
  28. How should I access a computed column in Entity Framework Code First?
  29. Modelling polymorphic associations database-first vs code-first
  30. How can set a default value constraint with Entity Framework 6 Code First?

Leave a Comment