I have a the following function CreateAudiTrail (AuditTrail ATObj).
In this function I call first the Create sp and then the Update sp.
I want to track (without using triggers) the call made to these sps.
I will start a thread, threadCreate for the execution of Create Sp. One create is over, I want to check whether the threadCreate is still active and then execute the Update sp.
How do I access a session (or something similar) in the service layer of WCF architecture i.e. how can I check whether the threadCreate still exists when Update sp is executed?
It would great if anyone could give me a lead to the solution!