title: Foreign key created in shadow and appending random 1 to column name ASP:NET EF Core
body: <p>When I migrate my new models and data I get the following error for multiple foreign keys:</p>
  <blockquote>
  <p>The foreign key property 'FavoriteList.SongId1' was created in shadow
  state because a conflicting property with the simple name 'SongId'
  exists in the entity type, but is either not mapped, is already used
  for another relationship, or is incompatible with the associated
  primary key type. See <a href="https://aka.ms/efcore-relationships" rel="nofollow noreferrer">https://aka.ms/efcore-relationships</a> for
  information on mapping relationships in EF Core.
  Example of my models:</p>
  </blockquote>
  <pre><code>public class FavoriteList
      {
          [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
          public int Id { get; set; }
          public int MovieId { get; set; }
          [ForeignKey(&quot;MovieId&quot;)]
          public int SongId { get; set; }
          [ForeignKey(&quot;SongId&quot;)]
          public int CustomerId { get; set; }
          [ForeignKey(&quot;CustomerId&quot;)]
          public virtual Movie Movie { get; set; }
          public virtual Song Song { get; set; }
          public virtual Customer Customer { get; set; }
      }
  </code></pre>