CreatedOn column in Entity Framework 6

Question

After upgrading to Entity Framework 6 we've implemented our own DbExecutionStrategy. In addition to existing SqlAzureExecutionStrategy, our strategy also logs exceptions. As turned out, every 15-30 minutes Entity Framework throws internal SqlException  System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedOn'. It's an internal error. Seems like EF does some regular checks if the CreatedOn column exists on some table. Is there any elegant way to prevent this exception to be thrown?

Answer 1

If you are working on Visual Studio, try resetting it. 

Before you reset it, make sure you have a backup. You can do so with the following steps:

1. Remove MigrationHistory table from the Database

2. Remove individual migration files that’s in your project migration folder

3. Enable-Migrations in Package Manager Console

4. Add migration Initial in PMC

5. Comment the code inside of the Up method in the Initial Migration

6. Update the database in PMC (does nothing but creates Migration Entry)

7. Remove comments in the Initial method