Entity Framework Core Many to Many change navigation property names

by

Interesting bug, consider posting it to EF Core GitHub issue tracker.

By idea what you have tried should do it

modelBuilder.Entity<SystemUser>()
    .HasMany(x => x.LogBooks)
    .WithMany(x => x.SystemUsers)
    .UsingEntity<Dictionary<string, object>>("LogBookSystemUsers",
        x => x.HasOne<LogBook>().WithMany().HasForeignKey("LogBookId"),
        x => x.HasOne<SystemUser>().WithMany().HasForeignKey("SystemUserId"),
        x => x.ToTable("LogBookSystemUsers", "LogBooks"));

And it works for any other FK property names except the {RelatedEntity}Id when related entity PK property is called ID.

As workaround until it gets fixed, define explicitly the desired join entity properties before configuring the relationship:


// add this
modelBuilder.SharedTypeEntity<Dictionary<string, object>>("LogBookSystemUsers", builder =>

{
    builder.Property<int>("LogBookId");
    builder.Property<int>("SystemUserId");
});
// same as the original
modelBuilder.Entity<SystemUser>()
    .HasMany(x => x.LogBooks)
    .WithMany(x => x.SystemUsers)
    .UsingEntity<Dictionary<string, object>>("LogBookSystemUsers",
        x => x.HasOne<LogBook>().WithMany().HasForeignKey("LogBookId"),
        x => x.HasOne<SystemUser>().WithMany().HasForeignKey("SystemUserId"),
        x => x.ToTable("LogBookSystemUsers", "LogBooks"));

More Related Contents:

  1. Entity Framework core – Contains is case sensitive or case insensitive?
  2. Get SQL code from an Entity Framework Core IQueryable
  3. Dynamically access table in EF Core 2.0
  4. How to mock an async repository with Entity Framework Core
  5. Cannot access a disposed object in ASP.NET Core when injecting DbContext
  6. How to instantiate a DbContext in EF Core
  7. Map category parent id self referencing table structure to EF Core entity
  8. Filter all queries (trying to achieve soft delete)
  9. The entity type ‘Microsoft.AspNet.Identity.EntityFramework.IdentityUserLogin’ requires a key to be defined
  10. Cascade deleting with EF Core
  11. EF CORE 2.1 HasConversion on all properties of type datetime
  12. Include with FromSqlRaw and stored procedure in EF Core 3.1
  13. How to make EF-Core use a Guid instead of String for its ID/Primary key
  14. How to seed in Entity Framework Core 2?
  15. The LINQ expression could not be translated and will be evaluated locally
  16. Entity Framework Core: Guid Greater Than for Paging
  17. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  18. Add migration with different assembly
  19. ASP – Core Migrate EF Core SQL DB on Startup
  20. EF models. Navigation properties can only participate in a single relationship
  21. ef core doesn’t use ASPNETCORE_ENVIRONMENT during update-database
  22. How to load navigation properties on an IdentityUser with UserManager
  23. Use both AddDbContextFactory() and AddDbContext() extension methods in the same project
  24. How to get user information in DbContext using Net Core
  25. How to create a password protected database?
  26. Implementing recursive property loading in EF Core
  27. How to set Identity Seed value in code-first?
  28. EF Core takes a lot of time, sometimes, to perform SELECT query
  29. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  30. How to access DbContext in .NET 6 minimal API Program.cs

Leave a Comment