I am using SqlHelper from the MS Data Access Application Block and the
stored procedure I am calling takes about 1 minute to execute.
Therefore, a command timeout occurs because the default timeout value
is 30 seconds. Since the Command object is created in the Application
Block, I cannot explicitly (that I know of) set a specific timeout
value. Does anyone have any suggestions on how I can overcome this
obstacle? Is there some config value that I can add to override the
default Command timeout value? Any and all help is greatly
appreciated.
|