Implementing Zero Or One to Zero Or One relationship in EF Code first by Fluent API

by

By changing pocos to:

public class Order
{
    public int OrderId { get; set; }
    public virtual Quotation Quotation { get; set; }
}
public class Quotation
{
    public int QuotationId { get; set; }
    public virtual Order Order { get; set; }
}

and using these mapping files:

public class OrderMap : EntityTypeConfiguration<Order>
{
    public OrderMap()
    {
        this.HasOptional(x => x.Quotation)
            .WithOptionalPrincipal()
            .Map(x => x.MapKey("OrderId"));
    }
}

public class QuotationMap : EntityTypeConfiguration<Quotation>
{
    public QuotationMap()
    {
        this.HasOptional(x => x.Order)
            .WithOptionalPrincipal()
            .Map(x => x.MapKey("QuotationId"));
    }
}

we will have this DB(that means 0..1-0..1):

enter image description here

with special thanks to (Mr. Vahid Nasiri)

More Related Contents:

  1. Decimal precision and scale in EF Code First
  2. Entity Framework Stored Procedure Table Value Parameter
  3. Ignoring a class property in Entity Framework 4.1 Code First
  4. The entity type is not part of the model for the current context
  5. How can I automatically filter out soft deleted entities with Entity Framework?
  6. EF Including Other Entities (Generic Repository pattern)
  7. composite key as foreign key
  8. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  9. Many-to-many mapping table
  10. One to one optional relationship using Entity Framework Fluent API
  11. EF Code First: How to get random rows
  12. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  13. Entity Framework Code First Lazy Loading
  14. How to disable cascade delete for link tables in EF code-first?
  15. Mapping Database Views to EF 5.0 Code First w/Migrations
  16. Entity framework, problems updating related objects
  17. Navigation Property without Declaring Foreign Key
  18. Optimistic concurrency: IsConcurrencyToken and RowVersion
  19. EF4 Code First: how to add a relationship without adding a navigation property
  20. An error occurred while saving entities that do not expose foreign key properties for their relationships
  21. How do I specify that a property should generate a TEXT column rather than an nvarchar(4000)
  22. How to Specify Primary Key Name in EF-Code-First
  23. Entity Framework: Duplicate Records in Many-to-Many relationship
  24. Mixing Fluent API and DataAnnotations in EF code first
  25. Entity Framework Code First naming conventions – back to plural table names?
  26. The relationship could not be changed because one or more of the foreign-key properties is non nullable
  27. How should I set up my integration tests to use a test database with Entity Framework?
  28. Entity Framework: field of composite key cannot be nullable?
  29. How should I access a computed column in Entity Framework Code First?
  30. How can set a default value constraint with Entity Framework 6 Code First?

Leave a Comment