Entity Framework Id column issue

asp.net-mvc, c#, entity-framework

Solution

The problem is at your `Company` class configuration. Try:

public class CompanyMap : EntityTypeConfiguration<Company>
{
  public CompanyMap()
  {
    // Add this
    this.HasRequired(x => x.CreatedByProfile).WithMany().Map(
      x => x.MapKey("CreatedByProfileId"));

    // CreatedByProfileId is the FK column in the Company table that points
    // to the Profile table. This is my made up name for the column since
    // I don't know the real name in your database.
  }
}

If you don't have a configuration class for `Company` then in your `OnModelCreating` method you need:

modelBuilder.Entity<Company>().HasRequired(x => x.CreatedByProfile).WithMany().Map(
  x => x.MapKey("CreatedByProfileId"));

UPDATE Since you already have the property in your class.

modelBuilder.Entity<Company>().HasRequired(
  x => x.CreatedByProfile).WithMany().HasForeignKey(x => x.CreatedBy);

Problem

I have a problem with EF at the moment. I have an existing database and in there is a custom User table called Profiles. The user is below (I have stripped out most of the properties for easy reading). ``` public partial class Profile : IdentityUser { public Profile() { this.Assets = new List<Asset>(); // ... } public string CompanyId { get; set; } // ... public virtual Company Company { get; set; } public virtual ICollection<Asset> Assets { get; set; } // ... } ``` and my DbContext looks like this (simplified): ``` public partial class SkipstoneContext : IdentityDbContext<Profile> { static SkipstoneContext() { Database.SetInitializer<SkipstoneContext>(null); } public SkipstoneContext() : base("DefaultConnection") { } public DbSet<Asset> Assets { get; set; } // ... } protected override void OnModelCreating(DbModelBuilder modelBuilder) { // ... modelBuilder.Entity<IdentityUserLogin>().HasKey<string>(l => l.UserId); modelBuilder.Entity<IdentityRole>().HasKey<string>(r => r.Id); modelBuilder.Entity<IdentityUserRole>().HasKey(r => new { r.RoleId, r.UserId }); modelBuilder.Entity<UserSecret>().HasKey<string>(r => r.UserName); } } ``` And I have a class that looks like this: ``` public Company() { this.Assets = new List<Asset>(); } public string Id { get; set; } public string Name { get; set; } public string CreatedBy { get; set; } public string ModifiedBy { get; set; } public System.DateTime DateCreated { get; set; } public Nullable<System.DateTime> DateModified { get; set; } public bool Deleted { get; set; } public virtual Profile CreatedByProfile { get; set; } public virtual ICollection<Asset> Assets { get; set; } } ``` The problem is that when I run my code, I get an error stating: Invalid column name 'CreatedByProfile_Id'. I need to tell the system that the Id column for my custom user is just Id. I had a mapping file: ``` public class ProfileMap : EntityTypeConfiguration<Profile> { public ProfileMap() { // Primary Key this.HasKey(t => t.Id); // Properties this.Property(t => t.Id) .IsRequired() .HasMaxLength(128); this.Property(t => t.CompanyId) .IsRequired() .HasMaxLength(128); this.Property(t => t.CreatedBy) .IsRequired(); this.Property(t => t.Title) .IsRequired(); this.Property(t => t.Forename) .IsRequired(); this.Property(t => t.Surname) .IsRequired(); this.Property(t => t.Email) .IsRequired(); this.Property(t => t.CredentialId) .IsRequired(); // Table & Column Mappings this.ToTable("Profiles"); this.Property(t => t.Id).HasColumnName("Id"); this.Property(t => t.CompanyId).HasColumnName("CompanyId"); this.Property(t => t.CreatedBy).HasColumnName("CreatedBy"); this.Property(t => t.ModifiedBy).HasColumnName("ModifiedBy"); this.Property(t => t.DateCreated).HasColumnName("DateCreated"); this.Property(t => t.DateModified).HasColumnName("DateModified"); this.Property(t => t.LastLoginDate).HasColumnName("LastLoginDate"); this.Property(t => t.Title).HasColumnName("Title"); this.Property(t => t.Forename).HasColumnName("Forename"); this.Property(t => t.Surname).HasColumnName("Surname"); this.Property(t => t.Email).HasColumnName("Email"); this.Property(t => t.JobTitle).HasColumnName("JobTitle"); this.Property(t => t.Telephone).HasColumnName("Telephone"); this.Property(t => t.Mobile).HasColumnName("Mobile"); this.Property(t => t.Photo).HasColumnName("Photo"); this.Property(t => t.LinkedIn).HasColumnName("LinkedIn"); this.Property(t => t.Twitter).HasColumnName("Twitter"); this.Property(t => t.Facebook).HasColumnName("Facebook"); this.Property(t => t.Google).HasColumnName("Google"); this.Property(t => t.Bio).HasColumnName("Bio"); this.Property(t => t.CompanyName).HasColumnName("CompanyName"); this.Property(t => t.CredentialId).HasColumnName("CredentialId"); this.Property(t => t.IsLockedOut).HasColumnName("IsLockedOut"); this.Property(t => t.IsApproved).HasColumnName("IsApproved"); this.Property(t => t.CanEditOwn).HasColumnName("CanEditOwn"); this.Property(t => t.CanEdit).HasColumnName("CanEdit"); this.Property(t => t.CanDownload).HasColumnName("CanDownload"); this.Property(t => t.RequiresApproval).HasColumnName("RequiresApproval"); this.Property(t => t.CanApprove).HasColumnName("CanApprove"); this.Property(t => t.CanSync).HasColumnName("CanSync"); this.Property(t => t.AgreedTerms).HasColumnName("AgreedTerms"); this.Property(t => t.Deleted).HasColumnName("Deleted"); this.Property(t => t.UserName).HasColumnName("UserName"); // Relationships this.HasRequired(t => t.Company) .WithMany(t => t.Users) .HasForeignKey(d => d.CompanyId); } } ``` but if I add that to my DbContext class I get an error stating: A configuration for type 'Models.Profile' has already been added. To reference the existing configuration use the Entity() or ComplexType() methods. I assume this is simple to fix, so could someone point me in the right direction please? Cheers, /r3plica

Original source