Entity framework : Invalid column name

Question

I am getting this strange error from Entity framework , I cant figure out what I am doing wrong ..

My DB context code.

  public DbSet<Interaction> Interactions { get; set; }

        public DbSet<User> Users { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            InteractionsDBContextConfig(modelBuilder);

            base.OnModelCreating(modelBuilder);
        }

        public static void InteractionsDBContextConfig(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
            // Interaction entity configuration.
            modelBuilder.Entity<Interaction>()
                .HasKey<int>(key => key.InteractionId);


            modelBuilder.Entity<Interaction>()
                .HasRequired<Form>(x => x.Form)
                .WithMany()
                .HasForeignKey(y => y.FormId);


            modelBuilder.Entity<Interaction>()
               .HasRequired<User>(x => x.User)
               .WithMany()
               .HasForeignKey(y => y.InteractionUserId);


            // User entity configuration.

            modelBuilder.Entity<User>()
                .HasKey<int>(x => x.UserId);

            modelBuilder.Entity<User>()
                .Property(x => x.UserName)
                .IsRequired()
                .HasColumnAnnotation(
                    IndexAnnotation.AnnotationName,
                    new IndexAnnotation(
                        new System.ComponentModel.DataAnnotations.Schema.IndexAttribute() { IsUnique = true }
                        )
                );
        }

My Entity

public class Interaction
    {
        public int InteractionId { get; set; }
        public int FormId { get; set; }
        public string InteractionName { get; set; }
        public virtual Form Form { get; set; }
        public int InteractionUserId { get; set; }

        public virtual User User { get; set; }
        public DateTime Deadline { get; set; }
        public int InteractionType { get; set; }
    }

when I do the following

var db = dbcontext.Interactions.ToList();

I get the following error

{"Invalid column name 'InteractionType'."}

I cant figure out why the error is showing up , why cant Entity framework see my column ? Changing the name of the column doesnt seem to help.

Did you migrate the changes? Check the database if there is a column named `InteractionType` in the table. — Taher Rahgooy, Aug 26 '15 at 15:10
@TaherRahgooy : I have updated the database and I can see the column with name InteractionType in it. — Pratik, Aug 26 '15 at 15:29
I suspect you connect to different database when migrating/updating and at runtime. — Gert Arnold, Aug 26 '15 at 21:48

Renan Silveira · Answer 1 · 2015-08-27T03:15:09.603

Probably you changed the Interactions class adding "InteractionType" property and it wasn't reflected on Database and you need to use Migrations.

Open the menu on Visual Studio View> Others Windows> Package Manager Console, after that on Package Manager Console write "Enable-Migrations" and press Enter.

Then will be generated a folder named "Migrations" in your project, into that folder contains Configuration class and there you need to set AutomaticMigrationsEnabled property to "true" like below.

  public Configuration()
    {
        AutomaticMigrationsEnabled = true;
    }

You come back to Package Manager Console and write the command "Update-Database" and your project will work again.

This is only for people that are starting from scratch. – Mark Jun 22 '23 at 09:49 — Mark, Jun 22 '23 at 09:49

score 0 · Accepted Answer · edited May 23 '17 at 12:10

0

I could not find the reason for the error getting shown.

I ended up resetting all my migrations by using the method mentioned here : https://stackoverflow.com/a/22451879/2794980

I guess the Migration history table and the migrations .CS files had some kind of mismatch.

Resetting everything solved my issue.

edited May 23 '17 at 12:10

Community

1
1

answered Sep 25 '15 at 08:44

Pratik

868
1
9
24

score 0 · Answer 3 · answered Jun 22 '23 at 09:46

I do not really have a clue what exactly went wrong in my case. I did upgraded the EF tools and I start getting the messages invalid column name. I solved it by removing all seed code in the OnModelCreating and then I also needed to remove this in Up method of the migration. Then I got a clean Migration script without the errors and the DB update was clean without errors. Now lets see if the next migration is clean from the start...

Entity framework : Invalid column name

3 Answers3

Linked