What construct to use to run a SQL Server query and do something else while waiting for the result?

Question

I would like to issue a SQL Server query (task1) and do some kind of monitoring in a loop (task2) while waiting for the query result. When task2 finds a certain condition is met, the query needs to be cancelled (I will use SQLCommand.Cancel()). This means either task2 can issue the cancel command, or signals task1 to cancel it. Either when the result is returned or the cancel happens, task2 ends and task1 continues executing to the end of the method.

What's an optimal and simple construct to use for this? TPL, Async/await, waithandles, events..? Using .NET 4.5 in a class (not UI).

noseratio · Accepted Answer · 2014-07-16 04:28:14Z

1

It depends on further specifics. You can get it done with TPL (Task.WhenAny, CancellationTokenSource), async/await and asynchronous TAP-based SQL APIs (e.g., SqlCommand.ExecuteNonQueryAsync).

Or, depending on what conditions you monitor in task2 and how their changes are propogated, you could use Reactive Extensions.

Using low-level threads and synchronization primitives APIs would be a wrong choice, they should rarely be used with .NET 4+.

answered Jul 16, 2014 at 4:28

noseratio

62.1k37 gold badges226 silver badges509 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What construct to use to run a SQL Server query and do something else while waiting for the result?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related