Installing CommandTimeout in Microsoft Application Access Block (SQLHelper)

Question

I am using a Data Access Application Block (SQLHelper) to execute SQL on a database. I have one request that takes longer than the default command timeout of 30 seconds. I want to disable the timeout, but I see no way to do this without opening the application block. Is there a way to change CommandTimeout without changing the SQLHelper class?

Answer 1

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

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

, DAAB

Manjesh

Answer 2

SQLHelper 'Database' DAAB. DbCommand.SetCommandTimeOut - .

Answer 3

If you are still using the old version of DAAB, there are many FillDataset overloads with the 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)