Entity Framework multi level inheritance using fluent

Question

I get an error when I want to create a multi-level table with fluent api for migration on Entity framework.

but I got fail:

SQLite Error 19: 'FOREIGN KEY constraint failed'.

The table structures are as follows:

    Base Entity just for Id

        public class MainArt : BaseEntity
{

    public Paper Paper { get; set; }
    public int PaperId { get; set; }
}


    public class Paper : BaseEntity
{
    public string Name { get; set; }
    public string PaperPrice { get; set; }
    public ColorType ColorType { get; set; }
    public int ColorTypeId { get; set; }
}


    public class ColorType : BaseEntity
{
    public string Name { get; set; }
}

MainArt --> Paper --> ColorType

EF Fluent as below:

MainArt:

        public void Configure(EntityTypeBuilder<MainArt> builder)
    {

        builder.Property(p => p.Id).IsRequired();
        builder.HasOne(p => p.Paper).WithMany().HasForeignKey(p => p.PaperId);

    }

Paper:

        public void Configure(EntityTypeBuilder<Paper> builder)
    {

        builder.Property(p => p.Id).IsRequired();
        builder.Property(p => p.Name).IsRequired().HasMaxLength(100);
        builder.Property(p => p.PaperPrice).IsRequired();
        builder.HasOne(p => p.ColorType).WithMany().HasForeignKey(p => p.ColorTypeId);

    }
}

ColorType and Paper created with migration but MainArt failed.

I searched the web and i think iam missing something. ToTable or one-to-many i don't know.

Thanks.

You should post the code that throws the exception.

Gert Arnold
– Gert Arnold

2022-06-19 18:04:00 +00:00
Commented Jun 19, 2022 at 18:04 — Gert Arnold
– Gert Arnold, Commented Jun 19, 2022 at 18:04

RBT · Accepted Answer · 2022-06-25 02:36:30Z

1

I found out why it is giving exception. The code is not wrong.

Failure to create one of the child tables causing the error.

Migration and seeding worked correctly when I created the child table correctly.

edited Jun 25, 2022 at 2:36

RBT

26.3k24 gold badges178 silver badges267 bronze badges

answered Jun 19, 2022 at 22:48

n'or

315 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework multi level inheritance using fluent

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related