>>>Why do you have them in separate transactions? It seems that they are bound together.
>>
>>They are two separate methods. For code re-use and maintenance.
>
>Then maybe the child method needs to be modified to accommodate calls from a parent. Just a suggestion.....
I may try creating a slightly different version of that method (another overload) that will add to the existing command.
For simplicity I just changed that particular test to set Rollback property to false and then back to true. I'll test this change in a moment. It is not that critical to not create extra rows, although I wanted to prevent making changes.
I'll see what will be the best approach.
If it's not broken, fix it until it is.
My Blog