I have been facing this problem usually when the database size increases and couple a parallel calls to sqlserver are sent for query then this problem can occur. I dig out the problem by googling it but did not find any solution without changing its source code i.e use the commandtimeout in command wrapper as described in the following link.
http://nettiers.com/FrequentlyAskedQuestions.ashx#I_set_the_codeNetTiersProviderDefaultCommandTimeoutcode_property_so_why_does_my_slow_Sproc_time_out_using_the_SQL_provider_8
We can change the template at all.After completing a huge application. After looking into this problem a lot. i reached at the solution.Nettiers structure use the defaultcommandtimeout property in the provider class which is exactly 30 by default retrieved from the template we people used usually. OK there is no problem at all.Only one thing that we have to use to set this property.i.e just to add the defaultcommandtimeout property to providers settings.
Just replace the below providers settings of the configuration file
Umar
http://nettiers.com/FrequentlyAskedQuestions.ashx#I_set_the_codeNetTiersProviderDefaultCommandTimeoutcode_property_so_why_does_my_slow_Sproc_time_out_using_the_SQL_provider_8
We can change the template at all.After completing a huge application. After looking into this problem a lot. i reached at the solution.Nettiers structure use the defaultcommandtimeout property in the provider class which is exactly 30 by default retrieved from the template we people used usually. OK there is no problem at all.Only one thing that we have to use to set this property.i.e just to add the defaultcommandtimeout property to providers settings.
Just replace the below providers settings of the configuration file
with
type="Northwind.Data.SqlClient.SqlNetTiersProvider, Northwind.Data.SqlClient"
connectionStringName="netTiersConnectionString"
providerInvariantName="System.Data.SqlClient"
entityFactoryType="Northwind.Entities.EntityFactory"
useEntityFactory="true"
enableEntityTracking="false"
enableMethodAuthorization="false"
useStoredProcedure="false" />
Change the defaultCommandTimeout according to your need
type="Northwind.Data.SqlClient.SqlNetTiersProvider, Northwind.Data.SqlClient"
connectionStringName="netTiersConnectionString"
providerInvariantName="System.Data.SqlClient"
entityFactoryType="Northwind.Entities.EntityFactory"
useEntityFactory="true"
enableEntityTracking="false"
enableMethodAuthorization="false"
defaultCommandTimeout="180"
useStoredProcedure="false" />
Umar
