title: Introducing FOREIGN KEY constraint error issue
body: <p>I am a bit confused as to why I am getting this error:</p>
  
  <pre><code>Introducing FOREIGN KEY constraint 'FK_QuestionTerms_Terms_TermId' 
  on table 'QuestionTerms' may cause cycles or multiple cascade paths. 
  Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other 
  FOREIGN KEY constraints. Could not create constraint. See previous errors.
  </code></pre>
  
  <p>I have a class Question and a class Term, Questions may have any number of Terms associated with them, and Terms may have any number of Questions associated with them. So I am attempting to create a many to many relationship between the two. First I attempted to use convention, and I am allowing EntityFramework to create the database. This is the Question class</p>
  
  <pre><code>public class Question
  {
      public Guid Id { get; set; }
      public int QuestionNumber { get; set; }
      public string StatementHtml { get; set; }
      public string AnswerHeaderHtml { get; set; }
      public string NotesHtml { get; set; }
      public Guid CategoryId { get; set; }
      public Guid CourseId { get; set; }
      public Guid QuestionTypeId { get; set; }
      public Guid? SimulationId { get; set; }
      public Guid? SimulationTabId { get; set; }
  
      public ICollection&lt;Term&gt; Terms { get; set; }
      public ICollection&lt;ReferenceItem&gt; ReferenceItems { get; set; }
  
  }
  </code></pre>
  
  <p>And here is the Term Class</p>
  
  <pre><code>public class Term
  {
     public Guid Id { get; set; }
     public string Name { get; set; }
     public string StatementHtml { get; set; }
     public string Authority { get; set; }
     public Guid ProductId { get; set; }
  
     public Product Product { get; set; }
     public ICollection&lt;Question&gt; Questions { get; set; }
  }
  </code></pre>
  
  <p>I have also attempted to override OnModelCreating as follows, both process result is the exact same error code. </p>
  
  <pre><code>protected override void OnModelCreating(DbModelBuilder modelBuilder)
  {
      modelBuilder.Entity&lt;Question&gt;()
          .HasMany(q =&gt; q.Terms)
          .WithMany(t =&gt; t.Questions)
          .Map(x =&gt;
              {
                  x.MapLeftKey("QuestionId");
                  x.MapRightKey("TermId");
                  x.ToTable("QuestionTerms");
              });
  } 
  </code></pre>