asp.net mvc 3 - Execute Code First Migrations is Grayed Out in Publish Settings

Question

Using Windows Azure and attempting to publish my MVC3 Application. The check box for Execute Code First Migration in the settings panel of the Publish web application is grayed out. What changes do I need to make to be able to enable it?

Answer 1

I believe you see the following "Execute Code First Migration" disabled when you try to publish your MVC application:

This is potentially because either you do not full code written for Code migration in your application as well no or incorrect DB setup in your web.config as described here.

In order to have Code Migration enabled, you must have a DB configured (in case of Windows Azure you need to provide SQL Database info in the web.config) in web.config and a complete class is written on how the code migration will happen depend on your model. Here is an example on how to achieve it.

http://msdn.microsoft.com/en-us/library/dd394698#efcfmigrations