Darren,

>Can you explain why the ExecScalar() method does NOT respect the fact that a business object is in a transaction, and creates its own connection object when it executes the query?

Can you explain the scenario in which you want to execute ExecScalar in the midst of a Save transaction?

Best Regards,