3

I have gone through many posts, but never found a problem similar to mine

For some reason I cannot correctly map relationship between classes while creating database using EF Code First

The classes are - Order abstract class

public abstract class Order : IObjectWithState
{
    public int OrderId { get; set; }

    public OrderType Type { get; set; }
    public string Status { get; set; }

    [NotMapped]
    public State ObjectState { get; set; }

    public string CustomerId { get; set; }
}

And two classes that implement it:

public class SampleOrder : Order
{
    public DateTime CreationDate { get; set; }
    public DateTime CompletionDate { get; set; }

    public virtual ICollection<OrderItem> OrderItems { get; set; }
    public virtual Address BillAddress { get; set; }
}

public class HideOrder : Order
{
    public DateTime CreationDate { get; set; }
    public DateTime CompletionDate { get; set; }
    public bool Paid { get; set; }

    public virtual ICollection<OrderItem> OrderItems { get; set; }
    public virtual Address BillAddress { get; set; }
}

This is Address class:

public class Address : IObjectWithState
{
    public int AddressId { get; set; }

    public string AddressLine { get; set; }
    public string Country { get; set; }
    public string PostalCode { get; set; }
    public bool Main { get; set; }
    public string CustomerId { get; set; }

    [NotMapped]
    public State ObjectState { get; set; }
}

My context class looks like so:

public PhoeniceContext() : base("Phoenice")
{
}

public DbSet<Address> Addresses { get; set; }
public DbSet<SampleOrder> SampleOrders { get; set; }
public DbSet<HideOrder> HideOrders { get; set; }
public DbSet<OrderItem> OrderItems { get; set; }

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<SampleOrder>().Map(m =>
    {
        m.MapInheritedProperties();
        m.ToTable("SampleOrders");
    });

    modelBuilder.Entity<HideOrder>().Map(m =>
    {
        m.MapInheritedProperties();
        m.ToTable("HideOrders");
    });
}

When I try to create the database I get an error saying:

The association 'SampleOrder_BillAddress' between entity types 'SampleOrder' and 'Address' is invalid. In a TPC hierarchy independent associations are only allowed on the most derived types.

If I comment out BillAddress properties from both order classes mapping to OrderItems behaves correctly. Why mapping to Address item doesn't work as well??

Bartosz
  • 4,542
  • 11
  • 43
  • 69

0 Answers0