Hey guys sorry if this is not the place to write this post.
I've encounter a problem while using transactions on asp.net
In a procedure i'm making an INSERT then I call a store procedure that passes some values to a data reader.
Well there's where the problem start, because while i'm reading this data reader I need to call another store procedure to make another insert.
Since in total I have 3 store procedures i decided to make a transaction on server side so i can rollback if any problem happens on last procedure for exemple.
My doubt relates to the data reader...somehow i can't call a store procedure inside the transaction if an data reader is in use. Is this true? Does the transaction have problems with this?
View Complete Post