You need to ensure that a stored procedure will be invoked when the ObjectContext.SaveChanges method is executed after an attached Product has changed
What are two possible TransactionScope constructors that you can use for the inner transaction to achieve this goal?