Executing Multiple oracle procedures Parallel( not in sequence) in dotnet

Question

Dear Team I have an requirement in windows applications that i have to execute 3 oracle procedures parllely in an single click event. is there is any way of doing this. Like 1) using the multi threading concept. 2) can we pass three procedures at a time in commandtext or any alternative way of doing this or any link related to it. Thanx in advance .

abdul gani shaik · Answer

hi Jon thanx for the code you have given.. actually i am trying to run 3 different oracle procedure not 3 different functions... and i need to run these all procedure in single click event.

Jan Montano · Answer

static void Main(string[] args) { Thread thread1 = new Thread(new ThreadStart(Procedure1)); Thread thread2 = new Thread(new ThreadStart(Procedure2)); Thread thread3 = new Thread(new ThreadStart(Procedure3)); thread1.Start(); thread2.Start(); thread3.Start(); Console.ReadLine(); } static void Procedure1() { for (int i=0; i { Console.WriteLine(i); } } static void Procedure2() { for (int i = 100; i { Console.WriteLine(i); } } static void Procedure3() { for (int i = 200; i { Console.WriteLine(i); } }

Ryan Alford · Answer

you should look into the BackgroundWorker class.