Entity Framework Code First – two Foreign Keys from same table

by

Try this:

public class Team
{
    public int TeamId { get; set;} 
    public string Name { get; set; }

    public virtual ICollection<Match> HomeMatches { get; set; }
    public virtual ICollection<Match> AwayMatches { get; set; }
}

public class Match
{
    public int MatchId { get; set; }

    public int HomeTeamId { get; set; }
    public int GuestTeamId { get; set; }

    public float HomePoints { get; set; }
    public float GuestPoints { get; set; }
    public DateTime Date { get; set; }

    public virtual Team HomeTeam { get; set; }
    public virtual Team GuestTeam { get; set; }
}


public class Context : DbContext
{
    ...

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Match>()
                    .HasRequired(m => m.HomeTeam)
                    .WithMany(t => t.HomeMatches)
                    .HasForeignKey(m => m.HomeTeamId)
                    .WillCascadeOnDelete(false);

        modelBuilder.Entity<Match>()
                    .HasRequired(m => m.GuestTeam)
                    .WithMany(t => t.AwayMatches)
                    .HasForeignKey(m => m.GuestTeamId)
                    .WillCascadeOnDelete(false);
    }
}

Primary keys are mapped by default convention. Team must have two collection of matches. You can’t have single collection referenced by two FKs. Match is mapped without cascading delete because it doesn’t work in these self referencing many-to-many.

More Related Contents:

  1. Entity Framework Code First Date field creation
  2. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  3. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  4. Ignoring a class property in Entity Framework 4.1 Code First
  5. Entity Framework .Remove() vs. .DeleteObject()
  6. Entity Framework Join 3 Tables
  7. Why use ICollection and not IEnumerable or List on many-many/one-many relationships?
  8. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  9. LINQ To Entities does not recognize the method Last. Really?
  10. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  11. Entity Framework DateTime and UTC
  12. Does Entity Framework Code First support stored procedures?
  13. Why is inserting entities in EF 4.1 so slow compared to ObjectContext?
  14. EF Code First: How to get random rows
  15. Fluent API, many-to-many in Entity Framework Core
  16. Can you create sql views / stored procedure using Entity Framework 4.1 Code first approach
  17. Understanding ForeignKey attribute in entity framework code first
  18. Eager , Lazy and explicit loading in EF6
  19. Navigation Property without Declaring Foreign Key
  20. Better way to query a page of data and get total count in entity framework 4.1?
  21. Self-referencing many-to-many recursive relationship code first Entity Framework
  22. EF4 Code First: how to add a relationship without adding a navigation property
  23. An error occurred while saving entities that do not expose foreign key properties for their relationships
  24. Can you get the DbContext from a DbSet?
  25. Entity Framework | Sequence contains more than one matching element
  26. mapping multiple tables to a single entity class in entity framework
  27. Change foreign key constraint naming convention
  28. Create association on non-primary key fields with Entity Framework 4.1 Fluent API
  29. How to remove child one to many related records in EF code first database?
  30. Entity Framework – Include Multiple Levels of Properties

Leave a Comment