EF Code First “Invalid column name ‘Discriminator'” but no inheritance

by

Turns out that Entity Framework will assume that any class that inherits from a POCO class that is mapped to a table on the database requires a Discriminator column, even if the derived class will not be saved to the DB.

The solution is quite simple and you just need to add [NotMapped] as an attribute of the derived class.

Example:

class Person
{
    public string Name { get; set; }
}

[NotMapped]
class PersonViewModel : Person
{
    public bool UpdateProfile { get; set; }
}

Now, even if you map the Person class to the Person table on the database, a “Discriminator” column will not be created because the derived class has [NotMapped].

As an additional tip, you can use [NotMapped] to properties you don’t want to map to a field on the DB.

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  3. Unique Key constraints for multiple columns in Entity Framework
  4. Entity Framework 6 Code first Default value
  5. EntityFramework code-first custom connection string and migrations
  6. Improve navigation property names when reverse engineering a database
  7. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  8. How do I detach objects in Entity Framework Code First?
  9. EF5 Code First Enums and Lookup Tables
  10. Debug code-first Entity Framework migration codes
  11. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  12. Entity framework code-first null foreign key
  13. Entity Framework loading child collection with sort order
  14. How do I singularize my tables in EF Code First?
  15. Set decimal(16, 3) for a column in Code First Approach in EF4.3 [duplicate]
  16. How to create index in Entity Framework 6.2 with code first
  17. DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID
  18. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  19. mapping private property entity framework code first [duplicate]
  20. What is the syntax for self referencing foreign keys in EF Code First?
  21. How to create index in Entity Framework 6.2 with fluent configuration
  22. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  23. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  24. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  25. EF Code First foreign key without navigation property
  26. Entity Framework Code First Using Guid as Identity with another Identity Column
  27. LINQ To Entities + Include + Anonymous type issue
  28. Why does EF5 code first use datetime2 when inserting a nullable datetime into the database?
  29. Can anyone spot why I keep getting this error testing the EF 5 beta
  30. Entity framework code first delete with cascade

Leave a Comment