Entity Framework - what is the current command timeout value

Question

I'm using Entity Framework 5 and I wish to know the command timeout value.

In order to do so, I cast the dbContext object to an ObjectContext and I access the CommandTimeout property.

int ? currentCommandTimeout = ((IObjectContextAdapter)dbContext).ObjectContext.CommandTimeout;

The current value of this property is null which means that the current command timeout is the default value of the underlying provider.

1. Who is the underlying provider?
2. How can I read (via EF code) the current command timeout value in this case?

MSDN ObjectContext CommandTimeout Property reference

EDIT: Thank you for explaining how to set the command timeout and finding the default command timeout value in the documentation. However, the question remains open. How, if possible, can you read the command timeout value in case of default, via EF.

Answer 1

From MSDN,

• CommandTimeout property gets or sets the timeout value, in seconds, for all object context operations.
• A null value indicates that the default value of the underlying provider will be used.

So, if you are not setting it explicitly through code or passing it in your connection string (in MySQL) , then it is the default value of your provider.

If you want to see a non-null value for CommandTimeout, then you will need to pass it in connectionString or set it through code.

Who is the underlying provider?

Underlying provider is the one you are passing in your connectionstring as providerName

<connectionStrings>
  <clear />
  <add name="Name" 
   providerName="System.Data.ProviderName" 
   connectionString="Valid Connection String;" />
</connectionStrings>

Here, System.Data.ProviderName is your underlying provider.

If you are using MySql or MS Sql, According to the MySql Documentation and MSDN,

• The default value is 30 secs.

• A value of 0 indicates an indefinite wait and should be avoided.

  Note :

The default command timeout can be changed using the connectionstring attribute Default Command Timeout in case of MySQL database providers.