C#•10mo ago

EFCore Multi-level relation

I have been wondering if it is possible to describe a multi level relation using the fluent api from EFCore.
For example

class User{
public ICollection<Group> MemberOfGroups;
}

public class Group {
public ICollection<GroupRole> Roles; 
}

public class GroupRole{
public ICollection<User> Members;
}

class User{
public ICollection<Group> MemberOfGroups;
}

public class Group {
public ICollection<GroupRole> Roles; 
}

public class GroupRole{
public ICollection<User> Members;
}

where MemberOfGroups is based on the Members from Roles from the Group?

Ishan•2/21/25, 8:34 AM

Confused about question

Joschi•2/21/25, 9:06 AM

Yes such relations are possible. You just define each relationship individually.

But I don't understand what you are asking in the last sentence?

dance?•2/21/25, 12:14 PM

there is nothing unusual for now
you have to define all the primary keys and then which direction you want the relationship (so for example if Group should have an FK to User or if there should be a third relationships table)