How to set CommandTimeout for DbContext?

c#, command-timeout, dbcontext, entity-framework-4

Solution

It will work with your method.

Or subclass it (from msdn forum)

public class YourContext : DbContext
{
  public YourContext()
    : base("YourConnectionString")
  {
    // Get the ObjectContext related to this DbContext
    var objectContext = (this as IObjectContextAdapter).ObjectContext;

    // Sets the command timeout for all the commands
    objectContext.CommandTimeout = 120;
  }
}

Problem

I am looking a way to set CommandTimeout for DbContext. After searching I found the way by casting DbContext into ObjectContext and setting value for CommandTimeout property of objectContext. ``` var objectContext = (this.DbContext as IObjectContextAdapter).ObjectContext; ``` But I have to work with DbContext.

Original source

Related problems