SQL Server columns missing in Entity Framework

Question

I'm using ASP.NET MVC 4, Entity Framework 6, Visual Studio 2013, IIS 7 and SQL Server 2012 Express. I recently made a change to our web app and added 2 columns using code-first migrations. Tested everything and it was working. Published everything to the web server and everything worked fine for about 4 hours and then we started getting invalid column name errors.

I started looking in the database and the 2 columns I added earlier were gone. I re-added the columns by using update-database command from VS2013 and everything was working again.

Where can I go to try and figure out what happened?

We are a small company and I'm the only it person. Thanks though. — user3064073, Commented Jul 31, 2014 at 19:39

tika · Accepted Answer · 2014-07-31 16:27:29Z

0

Go to Migrations folder change the value of AutomaticMigrationsEnabled in constructor of class Configuration to false

public Configuration()
{
      AutomaticMigrationsEnabled = false;
}

answered Jul 31, 2014 at 16:27

tika

344 bronze badges

I changed this and and it worked for a couple hours and then my users started getting this error Unable to update database to match the current model because there are pending changes and automatic migration is disabled. Either write the pending model changes to a code-based migration or enable automatic migration. Set DbMigrationsConfiguration.AutomaticMigrationsEnabled to true to enable automatic migration. You can use the Add-Migration command to write the pending model changes to a code-based migration.
– user3064073
Commented Jul 31, 2014 at 19:37

Add a comment |

MikeV · Accepted Answer · 2014-07-31 16:29:53Z

0

I would go into my SQL log to find out what happened. I do not think this had anything to do with Entity or your application. Unless your deployment web config connection string was pointing to your development database during the first 4 hours and then someone changed it to your production server.

answered Jul 31, 2014 at 16:29

MikeV

5853 silver badges11 bronze badges

Unfortunately I made the mistake of doing everything on the production database :(
– user3064073
Commented Jul 31, 2014 at 19:40

Add a comment |

Collectives™ on Stack Overflow

SQL Server columns missing in Entity Framework

2 Answers 2

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related