Entity Framework many-to-many self-reference

by

Ok, so because a lot of people answered this ;), I searched a little more and I found the solution for my case. The entity looks like:

public class User
{
    public int ID { get; set; }
    public string UserName { get; set; }

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

The modelBuilder:

modelBuilder.Entity<User>()
                .HasMany(x => x.Friends)
                .WithMany();

And finally I made helper methods BeFriend and BecomeTeacherStudent, which make sure that when you become friend with someone he becomes friend with you (and the respective thing for teacher-student).

More Related Contents:

  1. What effect(s) can the virtual keyword have in Entity Framework 4.1 POCO Code First?
  2. The specified type member is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  3. Entity Framework: Where do I extend the CSDL/MSL?
  4. Entity Framework Simple Generic GetByID but has differents PK Name
  5. Possible to default DateTime field to GETDATE() with Entity Framework Migrations?
  6. How to convert DbSet in Entity framework to ObjectQuery
  7. Entity Framework 4: Does it make sense to create a single diagram for all entities?
  8. Entity Framework: Set Delete Rule with CodeFirst
  9. LINQ to Entities case sensitive comparison
  10. Entity Framework 4 CTP 4 / CTP 5 Generic Repository Pattern and Unit Testable
  11. What are Independent Associations and Foreign Key Associations? [duplicate]
  12. Entity framework self referencing loop detected [duplicate]
  13. How to add validation to my POCO(template) classes
  14. LEFT JOIN in LINQ to entities?
  15. Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?
  16. Solution for: Store update, insert, or delete statement affected an unexpected number of rows (0) [closed]
  17. How do I use structural annotations to set SQL type to Date in model first approach
  18. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  19. The property ‘Id’ is part of the object’s key information and cannot be modified
  20. How to set default value for POCO’s in EF CF?
  21. Entity Framework creates a plural table name, but the view expects a singular table name?
  22. Upgrade EF 4 EDMX to EF 6
  23. Most efficient method of self referencing tree using Entity Framework
  24. Entity Framework – default values doesn’t set in sql server table
  25. Entity Framework Code First AddOrUpdate method insert Duplicate values
  26. Entity Framework initialization is SLOW — what can I do to bootstrap it faster?
  27. What causes .Attach() to be slow in EF4?
  28. How to in-code supply the password to a connection string in an ADO.Net Entity Data Model
  29. Changing Inherited Types in Entity Framework
  30. Using Include in Entity Framework 4 with lambda expressions

Leave a Comment