Specifies the number of seconds the provider waits before timing out an operation.

Data Type

int

Default Value

30

Remarks

This property defines the maximum amount of time, in seconds, that the driver waits for a command to complete before raising a timeout error.

If Timeout is set to 0, operations do not time out. They continue running until they succeed or fail due to another error.

If Timeout is set to a positive integer, the driver cancels the operation and raises an error if it exceeds the specified duration.

Timeout applies to various operations such as executing queries, establishing connections, or reading data streams.

This property is useful for controlling long-running operations or setting safe execution limits in applications that require predictable behavior.

Note: Timeout behavior may vary depending on the command type like query or stored procedure, and network conditions. Always consider the typical response time of your database operations when configuring this value.