Пример #1
0
        private static void MultiThreadedCancel(string constr, bool async)
        {
            using (SqlConnection con = new SqlConnection(constr))
            {
                con.Open();
                var command = con.CreateCommand();
                command.CommandText = "select * from orders; waitfor delay '00:00:08'; select * from customers";

                Thread  rThread1     = new Thread(ExecuteCommandCancelExpected);
                Thread  rThread2     = new Thread(CancelSharedCommand);
                Barrier threadsReady = new Barrier(2);
                object  state        = new Tuple <bool, SqlCommand, Barrier>(async, command, threadsReady);

                rThread1.Start(state);
                rThread2.Start(state);
                rThread1.Join();
                rThread2.Join();

                CommandCancelTest.VerifyConnection(command);
            }
        }
Пример #2
0
        private static void MultiThreadedCancel(string constr, bool async)
        {
            using (SqlConnection con = new SqlConnection(constr))
            {
                con.Open();
                var command = con.CreateCommand();
                command.CommandText = "select * from orders; waitfor delay '00:00:08'; select * from customers";

                Barrier threadsReady = new Barrier(2);
                object  state        = new Tuple <bool, SqlCommand, Barrier>(async, command, threadsReady);

                Task[] tasks = new Task[2];
                tasks[0] = new Task(ExecuteCommandCancelExpected, state);
                tasks[1] = new Task(CancelSharedCommand, state);
                tasks[0].Start();
                tasks[1].Start();

                Task.WaitAll(tasks, 15 * 1000);

                CommandCancelTest.VerifyConnection(command);
            }
        }