I have a .net 1.0 framework appln which supports multiple db's. I have a stored proc. which generates new id's . These new id is then supplied to the specific table for inserting new records.
Problem I am facing is : The procedure works for single iterations.
But the db enters in a dead lock state when I execute the sp in nested loop.
Process flow:
sp.dll->generates new rec id.
comp1.dll->generates new record for the table using sp.dll o/p.
comp2.dll->generates new record for another table using sp.dll o/p.
assume comp2.dll is instantiated in the comp1.dll code.
Regards,
Ajay
Problem I am facing is : The procedure works for single iterations.
But the db enters in a dead lock state when I execute the sp in nested loop.
Process flow:
sp.dll->generates new rec id.
comp1.dll->generates new record for the table using sp.dll o/p.
comp2.dll->generates new record for another table using sp.dll o/p.
assume comp2.dll is instantiated in the comp1.dll code.
Regards,
Ajay