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 are using 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 are using 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.
15 March 2022
17 February 2022
09 December 2019