Entity Framework Code First: How can I create a One-to-Many AND a One-to-One relationship between two tables?

by

I’ve struggled with this for almost the entire day and of course I wait to ask here just before finally figuring it out!

In addition to implementing the One to One as demonstrated in that blog, I also then needed to use the fluent api in order to specify the Many to Many since the convention alone wasn’t enough with the One to One relationship present.

modelBuilder.Entity<Customer>().HasRequired(x => x.PrimaryMailingAddress)
    .WithMany()
    .HasForeignKey(x => x.PrimaryMailingAddressID)
    .WillCascadeOnDelete(false);

modelBuilder.Entity<Address>()
    .HasRequired(x => x.Customer)
    .WithMany(x => x.Addresses)
    .HasForeignKey(x => x.CustomerID);

And here is the final model in the database:
enter image description here

More Related Contents:

  1. The entity cannot be constructed in a LINQ to Entities query
  2. What does principal end of an association means in 1:1 relationship in Entity framework
  3. Decimal precision and scale in EF Code First
  4. Entity Framework .Remove() vs. .DeleteObject()
  5. How to add/update child entities when updating a parent entity in EF
  6. How to use a string to create a EF order by expression?
  7. Many-to-many mapping table
  8. Why is inserting entities in EF 4.1 so slow compared to ObjectContext?
  9. Entity Framework error: Cannot insert explicit value for identity column in table
  10. Dynamic MySQL database connection for Entity Framework 6
  11. How do I clear tracked entities in entity framework
  12. How to disable cascade delete for link tables in EF code-first?
  13. Entity framework, problems updating related objects
  14. Dynamic table name in linq [duplicate]
  15. Navigation Property without Declaring Foreign Key
  16. Entity Framework Specification Pattern Implementation
  17. Join and Include in Entity Framework
  18. Entity Framework 6 transaction rollback
  19. Creating dynamic queries with entity framework
  20. How to I apply filter while paginating in Asp.net MVC and entity Framework?
  21. EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata
  22. Json.Net adding $id to EF objects despite setting PreserveReferencesHandling to “None”
  23. Remove item from list based on condition
  24. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  25. Entity Framework – how do I get the columns?
  26. Stored procedure returns int instead of result set
  27. Create association on non-primary key fields with Entity Framework 4.1 Fluent API
  28. Adding a custom query backed Navigation Property to ODataConventionModelBuilder
  29. Net Core: Using OData in Onion Architecture, Convert Query Parameters Into Linq
  30. Migrations in Entity Framework in a collaborative environment

Leave a Comment