This question is locked. New answers and comments are not allowed.
Hi,
I've added to my configuration those lines (using oracle):
<section name="openAccessConfiguration" type="Telerik.OpenAccess.Config.OpenAccessConfigSectionHandler, Telerik.OpenAccess" requirePermission="false" />
<openAccessConfiguration>
<backendConfiguration name="ReportsConfiguration" backend="Oracle">
<runtime commandTimeout="6000"></runtime>
</backendConfiguration>
</openAccessConfiguration>
In code I've also added this:
BackendConfiguration fromCodeConfiguration =EntitiesModel.GetBackendConfiguration();
BackendConfiguration.MergeBackendConfigurationFromConfigFile(fromCodeConfiguration, ConfigurationMergeMode.ConfigFileDefinitionWins, "ReportsConfiguration");
Logger.Info(string.Format("CommandTimeout chenged to {0}", fromCodeConfiguration.Runtime.CommandTimeout));
using (EntitiesModel dbContext = new EntitiesModel(fromCodeConfiguration))
...
var result = dbContext.ExecuteQuery<Reports_Classes.IloscWKategoriachData>(query).ToList();
...
In my logger I see that fromCodeConfiguration.Runtime.CommandTimeout shows 6000 but nevertheless I'm still getting error "user requested cancel operation" after 30seconds.
What else I should do to make it work?
Regards,
Sebastian
I've added to my configuration those lines (using oracle):
<section name="openAccessConfiguration" type="Telerik.OpenAccess.Config.OpenAccessConfigSectionHandler, Telerik.OpenAccess" requirePermission="false" />
<openAccessConfiguration>
<backendConfiguration name="ReportsConfiguration" backend="Oracle">
<runtime commandTimeout="6000"></runtime>
</backendConfiguration>
</openAccessConfiguration>
In code I've also added this:
BackendConfiguration fromCodeConfiguration =EntitiesModel.GetBackendConfiguration();
BackendConfiguration.MergeBackendConfigurationFromConfigFile(fromCodeConfiguration, ConfigurationMergeMode.ConfigFileDefinitionWins, "ReportsConfiguration");
Logger.Info(string.Format("CommandTimeout chenged to {0}", fromCodeConfiguration.Runtime.CommandTimeout));
using (EntitiesModel dbContext = new EntitiesModel(fromCodeConfiguration))
...
var result = dbContext.ExecuteQuery<Reports_Classes.IloscWKategoriachData>(query).ToList();
...
In my logger I see that fromCodeConfiguration.Runtime.CommandTimeout shows 6000 but nevertheless I'm still getting error "user requested cancel operation" after 30seconds.
What else I should do to make it work?
Regards,
Sebastian