Executing commands asynchronously has the advantage of not blocking the application’s thread while the command is being processed by the Advanced SQL Engine. For example, a WinForms application could submit a long-running query without blocking its main thread while the query is being executed on a worker thread.

The following Asynchronous Programming Patterns are supported for query execution:

1. Asynchronous Programming Model (APM)
2. Task-based Asynchronous Pattern (TAP)

 

See Also

Re-tryable Exceptions

Exceptions that are not re-tryable