Im using SqlHelper.ExecuteReader to query the databse, but the problem is that the querystring is quite long. Is it possible to change the CommandTimeout somehow so that the query has time to process?
Hi. It's a sad thing, but there's absolutely no way to set CommandTimeout through the connection string or any other configuration setting. May be in your situation you could just put off using SqlHelper and simply use SqlCommand manually in order to set a longer timeout on it in your code.
Timeout expired when using SqlHelper.ExecuteReader
Hi!
Im using SqlHelper.ExecuteReader to query the databse, but the problem is that the querystring is quite long. Is it possible to change the CommandTimeout somehow so that the query has time to process?
Hi. It's a sad thing, but there's absolutely no way to set CommandTimeout through the connection string or any other configuration setting. May be in your situation you could just put off using SqlHelper and simply use SqlCommand manually in order to set a longer timeout on it in your code.
is working on a reply...