Sql Helper

Question

User2101710649 posted

 Hi

 I am using sql Helper for Data Access.I am implemented the connection pooling in web.config. I have 10000 records.I am using view to retrive the record from different tables from sqlserver. I got the Error  is below while access from application.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Please give me the any solution for this problem.

 

 

 

Answer 1

User-158764254 posted

The old SQLHelper class does not give you access to the CommandTimeout setting so you only get the default 30 seconds.

If you want to change the timeout, you'd need to alter the SQLHelper code slightly (http://bytes.com/topic/c-sharp/answers/513212-increase-daab-time-out)

Or you could skip SQLHelper and create your own SQLCommand for your long running calls