Running Stored Procedures in Async?

[adshocker]

You don't want to abort threads. You want to call the Cancel method of the command object. As such, you'll need to store them somewhere that they can be accessed when required. That means that you'll need a collection of some sort assigned to a member variable. The StartProgram method can add the command it creates to that collection so that it can be accessed from another method on another thread to call its Cancel method. Once the command completes, it can be removed from the collection.

Will the command object have some sort of Unique Identifier that I can store in a database table? Currently this is what I'm doing when running actual Executable files initiated using Process object. Fortunately this returns a PID which I use later on when I need to kill the Process.