title: Entity framework Invalid Column name, EF adds number 1 to primary key
body: <p>I have these two entities:</p>
  
  <pre><code>public partial class Suscriptores
  {
      public Suscriptores()
      {
         this.Publicacion = new HashSet&lt;Publicacion&gt;();
      }
  
      [Key]
      public int IdSuscriptor { get; set; }
      public string LogoSuscriptor { get; set; }
      public string Identificacion { get; set; }
      public string Nombre { get; set; }
      public string Direccion { get; set; }
      public string Telefono { get; set; }
      public string Email { get; set; }
      public string Fax { get; set; }
      public string Home { get; set; }
  
      public virtual ICollection&lt;Publicacion&gt; Publicacion { get; set; }
  }
  
  public partial class Publicacion
  {
      public Publicacion()
      {
          this.Edictos = new HashSet&lt;Edictos&gt;();
      }
  
      [Key]
      public decimal IdPublicacion { get; set; }
      public System.DateTime FechaPublicacion { get; set; }
      public string IdUsuario { get; set; }
      public System.DateTime FechaPublicacionHasta { get; set; }
      public System.DateTime FechaArchivoHasta { get; set; }
      public int IdSuscriptor { get; set; }
      public decimal IdTipoPublicacion { get; set; }
  
      [ForeignKey("IdSuscriptor")]
      public virtual Suscriptores Suscriptores { get; set; }
  }
  </code></pre>
  
  <p>When I try to run this query:</p>
  
  <pre><code>public ActionResult DetailsVSTO(string Identificacion)
  {
      var SusQ = from s in db.Suscriptores
                 where s.Identificacion == Identificacion
                 select s;
  
      return Json(SusQ.First(), JsonRequestBehavior.AllowGet);
  }
  </code></pre>
  
  <p>It throw this message:</p>
  
  <blockquote>
    <p>System.Data.SqlClient.SqlException: Invalid column name 'Suscriptores_IdSuscriptor1'</p>
  </blockquote>
  
  <p>Trying to solve this problem, I added this fluent API code at DBContext:</p>
  
  <pre><code>modelBuilder.Entity&lt;Suscriptores&gt;()
      .HasMany(x =&gt; x.Publicacion)
      .WithRequired(x =&gt; x.Suscriptores)
      .Map(a =&gt; a.MapKey("IdSuscriptor"));
  </code></pre>
  
  <p>But the problem persists. How can I solve this?</p>