Hello! Say that you have two tables and for each table you have a Business Object. What If I want to put both tables in a transaction? Is there a way to control this (Transaction between these 2 BO's), or should I control transactions on stored procedures in one custom method in one of the BO's?

Thank you!

The only time that I ever recommend wrapping up transactions in the DB is when all INSERT logic, etc. will be server side, otherwise doing the transaction on the DB is more work and requires more code client side if this isn't the case. So yes, I would recommend doing this within the BO since this logic is tied into the BO.