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();
}
---------------------

Do I need to create a worker thread for this?

--
Thanks,
John

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/d...printable.html
"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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();
> }
> ---------------------
>
> Do I need to create a worker thread for this?
>
> --
> Thanks,
> John
>