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.