title: Many-to-many relationship with Entity Framework and MVC with ordering
body: <p>I am using Code First with POCO with Entity Framework 4 to create a many-to-many relationship. The JOIN table is correctly created to link the two entities. However, I need an additional column in the JOIN table to create an ordering in the relationship. Any way to archive this? How do the POCO objects have to be modified to include the additional index column in the JOIN table to allow the ordering? Is this even possible with Code First? If not, how should I proceed?</p>
  
  <pre><code>public class Product
  {
      public Guid ID { get; set; }
      public virtual IList&lt;Navigation&gt; Navigations { get; set; }
  }
  
  public class Navigation
  {
      public Guid ID { get; set; }
      public virtual IList&lt;Product&gt; Products { get; set; }
  }
  </code></pre>
  
  <p>A table with the following columns is automatically created, there I want an additional column for the ordering:</p>
  
  <pre><code>NavigationProducts
      Navigation_ID
      Product_ID
  </code></pre>
  
  <p>I could manually create the additional column, but this would break the automatic creation of the tables when the schema changes.</p>