Entity Framework – Add Navigation Property Manually

by

Yup – it’s not that straightforward.

Here’s what you do:

1 – Right click on the designer, Add -> Association

2 – Setup the association and cardinalities (People *..1 Gender, People *..1 Race)

3 – Go into the Model Browser -> Associations

4 – Right click on your newly created associations, click Properties

5 – Here you need to setup the endpoints for the key and cascade options. Make sure you get the endpoints correct. You can also setup a referential constraint here for your implicit navigational property.

6 – Map the navigational property to the relevant tables/fields.

7 – Validate your model, cross your fingers.

Hope this helps.

More Related Contents:

  1. There is already an open DataReader associated with this Command which must be closed first
  2. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  3. EF codefirst : Should I initialize navigation properties?
  4. Entity Framework Join 3 Tables
  5. Entity Framework Timeouts
  6. EF Including Other Entities (Generic Repository pattern)
  7. Entity Framework/Linq EXpression converting from string to int
  8. navigation property should be virtual – not required in ef core?
  9. LEFT JOIN in LINQ to entities?
  10. The mapping of CLR type to EDM type is ambiguous with EF 6 & 5?
  11. The result of a query cannot be enumerated more than once
  12. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  13. Entity Framework Code First Lazy Loading
  14. Internal .NET Framework Data Provider error 1025
  15. Entity Framework Include() is not working
  16. Creating dynamic queries with entity framework
  17. Better way to query a page of data and get total count in entity framework 4.1?
  18. Entity Framework Code Only error: the model backing the context has changed since the database was created
  19. EF4 Code First: how to add a relationship without adding a navigation property
  20. Entity Framework 4: How to find the primary key?
  21. How to Refresh DbContext
  22. Is it possible to prevent EntityFramework 4 from overwriting customized properties?
  23. Change db table name in EF4 (entity framework 4)
  24. Entity Framework Multiple Object Contexts
  25. Entity Framework Code First naming conventions – back to plural table names?
  26. Repository Pattern, POCO, and Business Entities
  27. Dynamically changing schema in Entity Framework Core
  28. Enable-Migrations Exception calling “SetData” with “2” argument(s)
  29. Save detached entity in Entity Framework 6
  30. .NET Managing Layers Relationships

Leave a Comment