Entity Framework Migrations: Timeout SqlException during migrating

command-timeout, entity-framework, entity-framework-migrations, sqlexception

Solution

I don't think this is possible in EF4. It was added as a feature to the release candidate of EF5 which was released this week: http://blogs.msdn.com/b/adonet/archive/2012/05/15/ef5-release-candidate-available-on-nuget.aspx

Problem

Sql Server is accessible. I want to migrate database using Entity Framework migrations. There i have "Images" table with 130k records having images. In migration there "INDEX" added to these table using "CREATE INDEX". I get `SqlException` that command timeout is expired. But in connection string i can define only Connect Timeout. I tried define Command Timeout here: `(IObjectContextAdapter)DbContext.ObjectContext.CommandTimeout` but it didn't help me. And in DbMigrator too, but he hasn't such property anywhere. So i need help, I should define `CommandTimeout` for migration in Entity Framework, but don't know how to do this. Help me plz, sorry for bad English

Original source