From MSDN,
- CommandTimeout property gets or sets the timeout value, in seconds, for all object context operations.
- A
nullvalue 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.