Setting CommandTimeout in Microsoft's Data Access Application Block (SQLHelper)

Question

I'm using the Data Access Application Block (SQLHelper) to execute SQL against a database. I have one query which takes longer than the default command timeout of 30 seconds. I want to up the timeout, but I don't see any way to do so without cracking open the Application Block. Is there any way to change the CommandTimeout without modifying the SQLHelper class?

I gave up and modified the application block. – Mashmagar Apr 18 '10 at 02:55 — Mashmagar, Apr 18 '10 at 02:55

score 3 · Answer 1 · answered May 19 '11 at 17:19

Well I could not find answer either, so what I did is, I copied the SQLHelper.cd from DAAB in to my project and started using that. ( Its just on file so it was easy )

Now I can change the connection timeout in SQLHelper.cs.

I have no clue on why this is not configurable in DAAB

Manjesh

score 2 · Answer 2 · edited May 23 '17 at 12:07

2

SQLHelper is replaced by 'Database' in newer versions of DAAB . You can then use DbCommand.SetCommandTimeOut - see here

edited May 23 '17 at 12:07

Community

1
1

answered Jan 17 '12 at 06:46

StuartLC

104,537
17
209
285

score 0 · Answer 3 · answered Feb 11 '14 at 22:41

If you still are using the old version of DAAB, there are numerous overloads of FillDataset that have command timeout as a parameter.

    public static void FillDataset(string connectionString, CommandType commandType, int commandTimeout, string commandText, DataSet dataSet, string[] tableNames)

    public static void FillDataset(string connectionString, CommandType commandType, int commandTimeout, string commandText, DataSet dataSet, string[] tableNames, params SqlParameter[] commandParameters)

    public static void FillDataset(string connectionString, string spName, int commandTimeout, DataSet dataSet, string[] tableNames, params object[] parameterValues)

    public static void FillDataset(SqlConnection connection, CommandType commandType, int commandTimeout, string commandText, DataSet dataSet, string[] tableNames)

    public static void FillDataset(SqlConnection connection, CommandType commandType, int commandTimeout, string commandText, DataSet dataSet, string[] tableNames, params SqlParameter[] commandParameters)

    public static void FillDataset(SqlConnection connection, string spName, int commandTimeout, DataSet dataSet, string[] tableNames, params object[] parameterValues)

    public static void FillDataset(SqlTransaction transaction, CommandType commandType, int commandTimeout, string commandText, DataSet dataSet, string[] tableNames)

    public static void FillDataset(SqlTransaction transaction, CommandType commandType, int commandTimeout, string commandText, DataSet dataSet, string[] tableNames, params SqlParameter[] commandParameters)

    public static void FillDataset(SqlTransaction transaction, string spName, int commandTimeout, DataSet dataSet, string[] tableNames, params object[] parameterValues)

Setting CommandTimeout in Microsoft's Data Access Application Block (SQLHelper)

3 Answers3