Entity Framework : Invalid Column after removing the column

Question

I have a table mapped in Entity Framework which works great adding/updating and deleting records. I removed a column from SQL sever called "Category", then re-mapped my entity in the model. This worked fine, the column disappeared.

Now, I run a query on the table to update a row and get the same error, invalid column "Category".

This has been removed from the SQL table and removed from the Entity, so is it still looking for this damn column when I run the following code??

using (Entities db = new Entities())
                { 
                       var Voucher = (from vouchers in db.Vouchers
                                 where vouchers.ID == ID
                                 select vouchers).FirstOrDefault();

                       if (Voucher != null)
                       {
                           Voucher.Status = (int)Vouchers.UI.Enums.VoucherStatus.Removed;                           
                           ret = db.SaveChanges() == 1;
                       }
                } 

Here is the error:

Invalid column name 'Category'.

I have cleaned the code, built, re-built, and updated the enitties about a 100 times.

Does anyone have any ideas?

Thanks

Answer 1

I used to also remove and re-add table, but never like this. What I rather do. I close model. right click and open as XML and them manually remove this reference. So it keeps my multiple diagrams within one model same and also my defined colors.

Answer 2

not necessary to remove the whole table from *.EDMX file, just remove the unnecessary field from *.EDMX file. It helped me