>>If say, you would be using an SP to update all 3 tables at once, you would not have this problem, but the question is how to pass parameters?
>>
>>In SQL Server 2005 you may pass XML as a parameter, but I don't think it would ease the process.
>>
>>E.g. if you somehow pass curUpdateTable1.XML (all updated fields for 1 table), same for the second and the third - I'm not sure how can you now handle it in SQL Server.
>>
>>How can we pass updated values for the fields in this SP?
>>
>
>I am not using SP for the updates. And I would like to keep updates of each module done via the module Business/DA class. So passing XML or doing anything in SP is not applicable for me here.
>
>Thank you for your suggestion.
In MereMortals this is done through Parent - Child relationship. The Parent class starts the transaction, then Saves, then try to Save all children...
If it's not broken, fix it until it is.
My Blog