EF Core - Many to many relationship on a class

c# entity-framework-core many-to-many

Question

User-Friend relationship

I find an answer

Entity Framework Core: many-to-many relationship with same entity and try like this.

Entitys:

public class User
{
    public int UserId { get; set; }

    public virtual ICollection<Friend> Friends { get; set; }
}

public class Friend
{
    public int MainUserId { get; set; }

    public User ManUser { get; set; }

    public int FriendUserId { get; set; }

    public User FriendUser { get; set; }
}

The fluent API:

modelBuilder.Entity<Friend>()
    .HasKey(f => new { f.MainUserId, f.FriendUserId });

modelBuilder.Entity<Friend>()
    .HasOne(f => f.ManUser)
    .WithMany(mu => mu.Friends)
    .HasForeignKey(f => f.MainUserId);

modelBuilder.Entity<Friend>()
    .HasOne(f => f.FriendUser)
    .WithMany(mu => mu.Friends)
    .HasForeignKey(f => f.FriendUserId);

When I Add-Migration, the error message is

Cannot create a relationship between 'User.Friends' and 'Friend.FriendUser', because there already is a relationship between 'User.Friends' and 'Friend.ManUser'. Navigation properties can only participate in a single relationship.

What should I do? Or I should create an Entity FriendEntity:User?

1
6
5/23/2017 11:55:04 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

The problem is that you can't have one collection to support both one-to-many associations. Friend has two foreign keys that both need an inverse end in the entity they refer to. So add another collection as inverse end of MainUser:

public class User
{
    public int UserId { get; set; }
    public virtual ICollection<Friend> MainUserFriends { get; set; }
    public virtual ICollection<Friend> Friends { get; set; }
}

And the mapping:

modelBuilder.Entity<Friend>()
    .HasKey(f => new { f.MainUserId, f.FriendUserId });

modelBuilder.Entity<Friend>()
    .HasOne(f => f.MainUser)
    .WithMany(mu => mu.MainUserFriends)
    .HasForeignKey(f => f.MainUserId).OnDelete(DeleteBehavior.Restrict);

modelBuilder.Entity<Friend>()
    .HasOne(f => f.FriendUser)
    .WithMany(mu => mu.Friends)
    .HasForeignKey(f => f.FriendUserId);

One (or both) of the relationships should be without cascading delete to prevent multiple cascade paths.

8
3/12/2017 9:06:45 AM

Popular Answer

It's not mandatory the second collection. You only need to left de .WithMany() empty like this:

modelBuilder.Entity<Friend>()
    .HasOne(f => f.MainUser)
    .WithMany()
    .HasForeignKey(f => f.MainUserId);

modelBuilder.Entity<Friend>()
    .HasOne(f => f.FriendUser)
    .WithMany()
    .HasForeignKey(f => f.FriendUserId);

look at this : https://github.com/aspnet/EntityFramework/issues/6052

Alejo Ferrand

Related Questions

EF Core - Many to many relationship on same class

You have to add the self Referencing Foreign-Key-Relationship as following:...public class Item { public Item() { RelatedItems = new List<Item>(); } public int ItemId { get; set; } public int? ParentItemId { get; set; } public Item ParentItem{ get; set; } public List<Item> RelatedItems { get; set; } } ...The fl...
c# entity-framework entity-framework-core
asked by Bassam Alugili

Where should my application setting be in a .Net Core / EF Core class library project?

When i look at this :...Entity Framework Core 1.0 Connection Strings...I think he used Json. Said it was easier, and managed to answer himself. Make sure your files see each other and it should be ok. Sorry if it didn't help.
.net-core c# entity-framework entity-framework-core
asked by Antoine Pelletier

How to get DbContext class in EF Core without bringing in EF 6?

This code has references to ...DbContext... (in ...System.Data.Entity...)...That seems to be your problem. Throw it away....The correct ...DbContext... lives in ...Microsoft.EntityFrameworkCore... namespace, from the same nuget package....Probably you should read ...this...:...Code First...DB First...Make sure you have the old nuget package uninsta...
.net-core c# entity-framework-core
asked by Christian Gollhardt

Use settings.json on a Net Core Class Library with EF Core migrations

IDesignTimeDbContextFactory..., as its name implies, is strictly for development. There is generally no need to externalize the connection string, because it should be pretty static, even in a team environment. That said, if anything, you should store it in user secrets, because again, this is only for development. Using user secrets keeps the conn...
asp.net-core dotnet-cli entity-framework-core
asked by Chris Pratt

ASP.NET Core Web API & EF Core Models with Foreign Key relationship

You need to ...load related data...So for example, for your ...MessageBoard... GET - ...// GET: api/MessageBoards/5...Change from:...var messageBoard = await _context.MessageBoards.FindAsync(id); ...To...var messageBoard = await _context.MessageBoards .Include(i=>i.Messages) .FirstOrDefaultAsync(i => ...
asp.net asp.net-web-api2 c# entity-framework entity-framework-core
asked by Alex

Can this TestDBSet class from EF 6 be adapted to work with EF Core?

@Edward your solution worked brilliantly, by returning null the tutorial is now compatible with EF core at least for my tests, thanks for the hint....some modifications in TestContext: - using Microsoft.EntityFrameworkCore.Query.Internal; - using Microsoft.EntityFrameworkCore.ChangeTracking; - change IDbAsyncEnumaerable and IDbAsyncEnumerator to IA...
.net-core c# dependency-injection entity-framework-core mocking
asked by Ahmed.Net

.net core C# use dynamic property name on EF Core Database first generated model class

You can do it via reflection for properties that exist on the object....C# has a feature called ...Indexers.... You could extend your code like this to allow for the behavior you are expecting.... public partial class UserDetails { public int? Level { get; set; } public string Unit { get; set; } public string Bio { get; ...
.net-core c# entity-framework-core
asked by Alen Genzić

EF Core 2 - Relationship with only 1 navigation property/relationship knowledge?

If you have an IntroTextId exposed in your Foo entity, then you need to associate it as the FK in the One-to-One relationship:...builder.HasOne(b => b.IntroText) .WithOne() .HasForeignKey(b => b.IntroTextId) .IsRequired(false); ...Normally though I don't want FK properties exposed in my entities because this causes two sources of truth ...
c# database ef-fluent-api entity-framework entity-framework-core
asked by Steve Py

EF Core unable to determine relationship represented by foreign keys in abstract class

A potential additional complication is that the User class also has a property of class Department, which is unrelated to the CreatedBy and ModifiedBy properties on Department....That's the problem - EF Core does not know whether they are unrelated, or it is related to one of them (and which one), so you have to configure that explicitly using the ...
c# ef-core-3.0 entity-framework-core
asked by Ivan Stoev

How do I properly define the relationship between these classes created by EF Core?

Since you are trying to define a one-to-one relationship you need to explicitly define the back reference id on your ...Dad... model to ensure it maps to a single ...DadCmu... record....public partial class Dad { public int DadCmuId { get; set; } public virtual DadCmu DadCmu { get; set; } } ...You can then configure this using the fluent AP...
c# entity-framework-core
asked by jcruz

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