Asynch stored proc calls

[John]

Hi,

I appologize for such a simple question that I should easily be able to find
on my own. But I am having a difficult time finding it today .. just not my
day I guess.

How do you make an asynchronous stored procedure call from IDbCommand?

Here is what I tried thinking it might just run asynch by default.
---------------------
public void Run()
{
IDbCommand cmd = myConnection.CreateCommand();
cmd.CommandText = "MySlowProc";
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}

 

[W.G. Ryan MVP]

You can create a delegate that matches the method that calls the routine
with the stored proc in it. Then you can just use .BeginInvoke. Or you can
use a Worker thread as well. Here's a quick example - you can just
substitue the routine you're using with the proc for it.

http://www.knowdotnet.com/articles/delegates-printable.html