entity-frameworksqlexceptionentity-framework-migrationscommand-timeout

Entity Framework Migrations: Timeout SqlException during migrating


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


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