Welcome to Ultra Developers.

the company that developes your success

Read Blog


Running a long time operations on the database using LLBLGen Pro.

Sometimes a query can take a long time to complete such as retrieving a large dataset that contains thouthands of database records. To run such queries, you have to set the command timeout of that operation.

To do so using the LLBLGen Pro O/R mapper

If you use the SelfServicing model of the LLBLGen Pro  use the DbUtils.CommandTimeOut  to set ADO.NET command timeout to a value other than the default of 30 seconds as  follows

DbUtils.CommandTimeOut = 120;

In the previous code sample it sets the ADO.NET command timeout to 120 seconds.

If you use the Adapter model of the LLBLGen Pro you can set the timeout for each query on a per-call basis, using the property DataAccessAdapter.CommandTimeOut. The default is 30 (seconds).

      DataAccessAdapter.CommandTimeOut = 120;

In the previous code sample it sets the adapter command timeout to 120 seconds.

Similar Posts