foreign key in TPH

[endink]

Hi,
When the top level entity in the hierarchy will repeat to generate the foreign key T-SQL。
example:

public class B : A { }
public class C : A { }

public abstract A class
{
    int ForeignId { get; set; }
}

public D class
{
    public ICollection<A> AList { get; set; }
}

the mapping code for 'D':

builder.Collection(p => p.AList).InverseReference().ForeignKey(e => e.ForeignId);

the T-sql will like this:

CREATE TABLE [A] (
        ....
        CONSTRAINT [FK_A_D_ForeignId] FOREIGN KEY ([ForeignId]) REFERENCES [D] ([Id]),
        CONSTRAINT [FK_A_D_ForeignId] FOREIGN KEY ([ForeignId]) REFERENCES [D] ([Id]),
        CONSTRAINT [FK_A_D_ForeignId] FOREIGN KEY ([ForeignId]) REFERENCES [D] ([Id])