Entity Framework Code First - Invalid column name 'Discriminator1'

Question

We are trying to migrate a simple membership application to Identity 2.0, but we are getting the following error.

Invalid column name 'Discriminator1'.
Invalid column name 'Discriminator1'.
Invalid column name 'Discriminator1'.

I could not find where the problem is as I have followed all the migration steps properly.

Can anyone help find where the problem might be and how to fix it?
Any suggestion is welcome.

We have the following code related the ASP.NET logins.

     [Table("AspNetUserLogins")]
     public partial class AspNetUserLogins : IdentityUserLogin<Guid>
     {

     }



    [Table("AspNetUserClaims")]
    public partial class AspNetUserClaims : IdentityUserClaim<Guid>
    {
    }



    [Table("t_User")]
    public partial class User : IdentityUser<Guid, AspNetUserLogins, AspNetUserInRoles, AspNetUserClaims>
    {   
        [Key]
        [Column("UserId")]
        [DatabaseGenerated(System.ComponentModel.DataAnnotations.Schema.DatabaseGeneratedOption.Identity)]
        public override Guid Id { get; set; }

        [Column("Username")]
        public override string UserName { get; set; }

        [NotMapped]
        public Guid UserId { get { return base.Id; } }

        public Guid ApplicationId { get; set; }

        public DateTime? CreationDate { get; set; }

        public string Discriminator { get; set; }

        public int? FailedPasswordAnswerAttemptCount { get; set; }

        public DateTime? FailedPasswordAnswerAttemptWindowStart { get; set; }
        ...

score 3 · Answer 1 · edited May 23 '17 at 11:59

The error Invalid column name 'Discriminator1'. is mainly associated with inheritance. By default, when a class inherits a model(i.e the entity/POCO associated with a table) the code first assumes that the inheriting class is mapped to a table in the database. But if this is NOT the case then use the [NotMapped] attribute just above the inheriting class name like follows:

[NotMapped]
public class ContactUsViewModel : Content
{
    public string FirstName { get; set; }

    public string LastName { get; set; }
    ...
}

Or using Fluent API configuration:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    // Ignore 'ContactUsViewModel' class as it is not mapped to database
    modelBuilder.Ignore<ContactUsViewModel >();
    ...
}

See the similar problem EF Code First "Invalid column name 'Discriminator'" but no inheritance

score 0 · Answer 2 · answered Sep 10 '18 at 20:56

If you have Enum in your model and When updated the existing function like below can fix

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{

    modelBuilder.Entity<MyModel>()
    ....
    .Map<AnnouncementEvent>(m => 
    m.Requires("Discriminator").HasValue(MyTypeEnum.Event.ToString()))
    ....
}

Entity Framework Code First - Invalid column name 'Discriminator1'

2 Answers2