Hai all,
I have two classes(say class A and class B) for two modules. Each have a function(Say FnA in Class A and FnB in Class B) inserting values to two separate tables.
I am using enterprize library for connection to data base.
These two modules work independently well.
Now i wrote a new class and wrote a function which calls FnA and FnB. I wrote this inside a transaction so that if fnB fails the change caused by FnA will also be rolled back.
But when an exception occured in FnB the change caused by FnA is not rolled back.
Can anyone tell me the reason for it and how it can be solved?
Is it due to some problem with connection object? like the independent modules may be having some independent connection?
Thanks in advance.
Regards,
Simi