We are using Episerver Commerce version 10.7.1
Internally in Episerver Commerce, database lookups are made through the Mediachase.Data.Provider.SqlDataProvider class.
It is possible to set the database timeout in web.config like this:
This configuration seems to be used by most of the methods in the SqlDataProvider, but as far as I can see, the method called LoadDataSet(...) does not apply this commandTimeout setting.
To work around this problem, we have made our own version of the SqlDataProvider that contains this method:
public override DataResult LoadDataSet(DataCommand command)
command.CommandTimeout = CommandTimeOut;
But I would like to be able to remove our custom provider in the future :)
Anders Kåre Olsen
Thank you for your feedback - we will look into this issue.
This issue has been fixed in version 10.8.0, released on Jun 30 2017.