Entity Framework 4.1 InverseProperty Attribute and ForeignKey

by

It is theoretically correct but SQL server (not Entity framework) doesn’t like it because your model allows single employee to be a member of both First and Second team. If the Team is deleted this will cause multiple delete paths to the same Employee entity.

This cannot be used together with cascade deletes which are used by default in EF code first if you define foreign key as mandatory (not nullable).

If you want to avoid the exception you must use fluent mapping:

public Context : DbContext
{
    public DbSet<Employee> Employees { get; set; }
    public DbSet<Team> Teams { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        modelBuilder.Entity<Employee>()
                    .HasRequired(e => e.SecondTeam)
                    .WithMany(t => t.SecondEmployees)
                    .HasForeignKey(e => e.FirstTeamId)
                    .WillCascadeOnDelete(false);

        ...
    }
}

This will result in scenario where you must delete members of SecondTeam manually before you delete the team.

More Related Contents:

  1. Navigation Property without Declaring Foreign Key
  2. Unique key with EF code first
  3. Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship
  4. Ignoring a class property in Entity Framework 4.1 Code First
  5. Entity Framework Join 3 Tables
  6. Is DbContext thread safe?
  7. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  8. Mapping object to dictionary and vice versa
  9. How to retrieve Data Annotations from code? (programmatically)
  10. What is the effect of AsEnumerable() on a LINQ Entity?
  11. How to ignore null values for all source members during mapping in Automapper 6?
  12. EF Code First: How to get random rows
  13. Generic Way to Check If Entity Exists In Entity Framework?
  14. EF Code First – how to set identity seed?
  15. Can you create sql views / stored procedure using Entity Framework 4.1 Code first approach
  16. Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported
  17. Should I transform Entity (Persistent) objects to DTO objects?
  18. Can a DbContext enforce a filter policy?
  19. Entity Framework 4.1 InverseProperty Attribute
  20. How to configure many to many relationship using entity framework fluent API
  21. Better way to query a page of data and get total count in entity framework 4.1?
  22. LINQ to Entities does not recognize the method ‘Int32 Parse(System.String)’ method, and this method cannot be translated into a store expression
  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. Fluent NHibernate, working with interfaces
  26. What is the difference between IDbSet.Add and DbEntityEntry.State = EntityState.Added?
  27. DbSet table name
  28. mapping multiple tables to a single entity class in entity framework
  29. Entity Framework 4.1 DbSet Reload
  30. Class Mapping Error: ‘T’ must be a non-abstract type with a public parameterless constructor

Leave a Comment