Foreign key conflict ef core scaffolding

c# entity-framework-core

Question

The foreign key {'ClassExtId'} cannot be added to the entity type 'ClassInt' because a foreign key on the same properties already exists on entity type 'Instrument' and also targets the key {'ClassExtId'} on 'ClassExt'.

Let's say I have ClassFoo & ClassBar inheriting from ClassInt. Each one of them have a reference to the same column ClassExtId. Why is the entity framework core scaffolding (v3) complaining ?

1
3
10/15/2019 9:59:03 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

my case is different but i got the same error too when i was trying to scaffold my existing old database. i'm, posting this answer just in case someone also had the same problem with me.

it's turn out that in my old database, some table have so many duplicate foreign key created by previous developer. you can check this in your sql server (i use sql server developer edition 2019)

  1. In Object Explorer, right-click the table that will be on the foreign-key side of the relationship and click Design.
    The table opens in Table Designer.

  2. From the Table Designer menu, click Relationships. you'll see all the foreign key defined for that table, in my case it was applicationID that duplicate. clean it up : enter image description here

  3. go to your table > expand it and go to Keys. delete the duplicate key there: enter image description here

  4. run your dotnet ef dbcontext scaffold command and good luck!
1
1/28/2020 4:02:18 AM

Related Questions

EF 7 : INSERT statement conflicted with the FOREIGN KEY SAME TABLE

It seems to have changed in EF 7 ...See this github issue...Try ...public class Category { public Guid ID {get; set;} public Guid? ParentId {get; set;} public Category Parent {get; set;} public ICollection<Categories> Children {get; set;} } ...And ...modelBuilder.Entity<Category>() .HasOne(x => x.Parent) .WithMany(x => x.Ch...
asp.net-mvc c# entity-framework entity-framework-core sql-server
asked by ste-fu

The INSERT statement conflicted with the FOREIGN KEY constraint in Entity Framework Core

In your ...ApplicationDbContext... class you have to add a ...DbSet... for the ...Author... class and for the ...BookPage... class :...public class ApplicationDbContext : DbContext { public DbSet<Book> Books { get; set; } public DbSet<BookPage> BookPages { get; set; } public DbSet<Author> Authors { get; set; } ... } ...So that y...
c# entity-framework entity-framework-core
asked by Thomas

The INSERT statement conflicted with the FOREIGN KEY constraint in EF Core

First, you should reconsider your models. The phrase:...All managers are people but not all people are managers...does not translate into a many-to-many relationship. A student has many courses and a course has many students is a many-to-many relationship. Your situation translated better as: every manager ...is a... person which hints at inheritan...
asp.net-core c# entity-framework-core
asked by AlinG

EF Core: Using ID as Primary key and foreign key at same time

Here is the FluentAPI equivalent of @dmitry's solution:...// Model classes: public abstract class DtoBase { public Guid ID { get; protected set; } } public class PersonDto : DtoBase { public ProspectDto Prospect { get; set; } } public class ProspectDto : DtoBase { public PersonDto Person { get; set; } = new PersonDto(); } -----------...
c# ef-model-builder entity-framework-core
asked by Dominik

Asp.net core Identity "The INSERT statement conflicted with the FOREIGN KEY constraint "

Check the output of UserManager.CreateAsync call right before the error. I'm guessing your user doesn't get persisted so the next call fails with an FK issue....If you are using the default identity password requirements (like I was when I tried it) you get a password validation error result from the user creation call.
asp.net-identity asp.net-mvc c# entity-framework-core seeding
asked by Dave van Herten

Create Foreign Key to a Unique Key in another Entity with EF Core

(1) How do I get Program.Name property from ApplicantProgram knowing the FirstChoiceID that is to link to Program.ProgramCode?...There is nothing specific to EF here, you could use the typical data correlation operator - ...join.... Just because you have 3 related properties, you would need 3 ...join...s as well:...var query = from applicantPro...
asp.net-core entity-framework-core
asked by Ivan Stoev

EF Core: The INSERT statement conflicted with the FOREIGN KEY constraint

There are a couple of things wrong. Your linking table should not have a surrogate key, for one. Here's the Many-to-Many sample from the docs:...class MyContext : DbContext { public DbSet<Post> Posts { get; set; } public DbSet<Tag> Tags { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { mod...
c# entity-framework entity-framework-core
asked by David Browne - Microsoft

EF Core 2: The MERGE statement conflicted with the FOREIGN KEY constraint

Answer is not related to EntityFramework. In my case PlanarSurfaceId was set by default to 0. I changed it to null and it works.
.net-core-2.0 c# entity-framework-core tsql
asked by ael

The UPDATE statement conflicted with the FOREIGN KEY constraint in EF Core

Reason...I guess the reason is you're having your ...TournamentBatch... bind from client side . ...Let's review the ...OnPostAsync()... method:...public async Task<IActionResult> OnPostAsync(Guid? id) { try { if (await _context.TournamentBatch.AnyAsync( m => m.TournamentBatchID == id)) { _context.Tour...
asp.net-core asp.net-core-2.0 asp.net-core-2.1 c# entity-framework-core
asked by itminus

ASP.NET EF CORE: Composite key composed of two foreign keys not evaluating properly

I was able to solve the issue (only took all week). I modified my modelbuilders accordingly but also got rid of the "public Client Client" in the MachineBOB. Even though I need the ClientID the objects are not directly connected to each other. Here's the code for reference to anyone else who finds it worth critiquing further or for their own use on...
asp.net-core c# entity-framework-core sql
asked by Donar144

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow