title: Entity Framework 4.1 InverseProperty Attribute and ForeignKey
body: <p>I will create two references between Employee and Team entities with foreign keys.
  So I defined two entities as follow</p>
  
  <pre><code>public class Employee
  {
      public int EmployeeId { get; set; }
      public string Name { get; set; }
  
      [ForeignKey("FirstTeam")]
      public int FirstTeamId { get; set; }
  
      [InverseProperty("FirstEmployees")]
      public virtual Team FirstTeam { get; set; }
  
      [ForeignKey("SecondTeam")]
      public int SecondTeamId { get; set; }
  
      [InverseProperty("SecondEmployees")]
      public virtual Team SecondTeam { get; set; }
  }
  
  public class Team
  {
      public int Id { get; set; }
      public string TeamName { get; set; }
  
      [InverseProperty("FirstTeam")]
      public virtual ICollection&lt;Employee&gt; FirstEmployees { get; set; }
  
      [InverseProperty("SecondTeam")]
      public virtual ICollection&lt;Employee&gt; SecondEmployees { get; set; }
  }
  </code></pre>
  
  <p>I thought it is correct theoretically, but it shows the Exception as follow :</p>
  
  <pre><code>{"Introducing FOREIGN KEY constraint 'Employee_SecondTeam' on table 'Employees' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.\r\nCould not create constraint. See previous errors."}
  </code></pre>
  
  <p>Can anybody help me?</p>
  
  <p>Thanks in advance
  Kwon</p>