Entity Framework: Ignore Columns

by

Can you do this with the Entity Framework? Yes; it’s easy. Can you do this with the Entity Framework designer? Unfortunately, that is much harder.

The problem you’re having is that the column exists in the storage schema (SSDL) in your EDMX. Removing the column with the GUI designer simply removes it from the client schema, not the mapping or the storage schema. However, it’s simple enough to go into the EDMX and remove it. Having done that, you can also remove it from the mapping in the client schema portions of the EDMX, and the entity framework will longer complain that it is unmapped.

Problem solved, right?

Well, no. When you use the GUI designer to update the EDMX from the database, the storage schema is thrown away and re-generated. So your column will come back. As far as I know, there is no way to tell the GUI designer to never map a particular column. So you will have to re-do this every time you update with the GUI designer. Fortunately, the EDMX is XML, so you can do this with a XML transform, LINQ, or the XML tool of your choice.

More Related Contents:

  1. EF Core Second level ThenInclude missworks
  2. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  3. Disable lazy loading by default in Entity Framework 4
  4. Best way to check if object exists in Entity Framework? [closed]
  5. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  6. EF5 Code First Enums and Lookup Tables
  7. Entity Framework 4.1 DbContext Override SaveChanges to Audit Property Change
  8. Entity Framework One-To-One Mapping Issues
  9. How can I delete 1,000 rows with EF6?
  10. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  11. ef core 2 apply HasQueryFilter for all entity
  12. Value cannot be null. Parameter name: entitySet
  13. SQL Server Express connection string for Entity Framework Code First
  14. Entity Framework Code First – Advantages and disadvantages of Fluent Api vs Data Annotations [closed]
  15. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  16. EF Code First DBContext and Transactions
  17. How can I disable migration in Entity Framework 6.0
  18. How do I use Entity Framework in Code First Drop-Create mode?
  19. Many to Many Relationships not saving
  20. EF Code First foreign key without navigation property
  21. Nullable property to entity field, Entity Framework through Code First
  22. LINQ to Entities for subtracting 2 dates
  23. Entity Framework Code First Using Guid as Identity with another Identity Column
  24. AutomaticMigrationsEnabled false or true?
  25. ADO.NET Entity Framework tutorials [closed]
  26. Entity Framework Code First Many to Many Setup For Existing Tables
  27. Compose queries across Entity Data Models
  28. Changing Inherited Types in Entity Framework
  29. Why is my Entity Framework Code First proxy collection null and why can’t I set it?
  30. Why does the entity framework need an ICollection for lazy loading?

Leave a Comment