Entity Framework Code First : Setting up One-To-One foreign key association using Annotations

by

One-to-one foreign key associations are not supported by Entitiy Framework. You must remove the foreign key and use shared primary keys (primary key of the dependent is its foreign key to the principal at the same time):

public class StandardRack {
    public int Id {get;set}
    public StandardRelay StandardRelay {get;set} 
}

public class StandardRelay {
    public int Id {get;set} 
    public StandardRack StandardRack { get; set; }
}

Mapping in Fluent API:

modelBuilder.Entity<StandardRack>()
    .HasOptional(rack => rack.StandardRelay)
    .WithRequired(relay => relay.StandardRack);

(I’m assuing here that a StandardRack has an optional Relay.)

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  3. How do I detach objects in Entity Framework Code First?
  4. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  5. Entity framework code-first null foreign key
  6. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  7. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  8. Unique Key constraints for multiple columns in Entity Framework
  9. Entity Framework 6 Code first Default value
  10. EntityFramework code-first custom connection string and migrations
  11. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  12. Debug code-first Entity Framework migration codes
  13. How do I singularize my tables in EF Code First?
  14. Set decimal(16, 3) for a column in Code First Approach in EF4.3 [duplicate]
  15. How to map table splitting in EF Code First?
  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. Entity Framework 4.1 default eager loading
  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. An error occurred while saving entities that do not expose foreign key properties for their relationships
  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. Using the Entry().CurrentValues.SetValues() is not updating collections
  28. Model First with DbContext, Fails to initialize new DataBase
  29. Getting exact error type in from DbValidationException
  30. Entity framework code first delete with cascade

Leave a Comment