How to cancel execution of SqlCommand?

Question

.NET

Here is my method:
public static void Execute(SqlCommand command)
{
Thread rThread1 = new Thread(new ThreadStart(() => { command.ExecuteReader(); }));
Thread rThread2 = new Thread(new ThreadStart(() => { Thread_Cancel(command); }));
rThread1.Start();
rThread2.Start();
}
I get Exception:
Could not create constraint. See previous errors.
Operation canceled by user.
How to cancel execution of SqlCommand ?

Answer 1

If I'm not mistaken, you want to cancel the thread before it starts. Maybe this is an exception. So it throws an exception. It's most likely a matter of flows. Read how to work with them. My opinion