CODEWITHSUNDEEP
c#multithreadingsql-server-2008stored-proceduresmonitoring
comitatenses
comitatenses

Reputation: 15

Can two multi-threaded object call two different stored procedures from a database?

This is my first message.

I am trying to create a windows service that have three tables which two of them are stores coordinates and the last one stores the address information came from google api. System have two threads calling a SP that call parameter values for posting data to google. Another SP is used for storing retrieved data. BUT i need to code my threads to use different SPs(doing the same work at all).

how can i code my thread class to behave differently from others? (one use SP1 and one use SP2 like)

Thanks..

Upvotes: 0

Views: 329

Answers (1)

user47589
user47589

Reputation:

Start two different threads each with their own threadstart function. Don't start the threads using the same function.

Look at the example code here:

http://msdn.microsoft.com/en-us/library/system.threading.threadstart.aspx

Upvotes: 1

Related Questions