title: EF Code First: Duplicate foreign keys (one from name convention, one from navigation property)
body: <p>I'm trying to create an SQL database by using EF Code First.</p>
  
  <p>Assume I have the following code:</p>
  
  <pre><code>public class Account
  {
      public int Id;
      public ICollection&lt;User&gt; Users;
  }
  
  public class User
  {
      public int Id;
      public int AccountId;
  }
  
  public class AccountContext : DbContext
  {
      public DbSet&lt;Account&gt; Accounts;
      public DbSet&lt;User&gt; Users;
  }
  </code></pre>
  
  <p>(Note the lack of any Fluent API commands or Data Annotations; I want to do this by convention.)</p>
  
  <p>When the database is created, I get the following fields in the Users table:</p>
  
  <pre><code>Id
  AccountId
  Account_Id
  </code></pre>
  
  <p>Why isn't EF picking up on the fact that "AccountId" refers to the "Id" primary key (by convention) of Account?  I want to avoid mapping this manually with Fluent API/DA if possible, and I want to avoid having the Account navigation property on User.</p>