Oracle 11g, asp.net app.

I need to be able to call a stored procedure setting some transaction level variables (ex: username logged in) before any entity save. I don't want to pass these variables to each and every save. I'm hoping to set up a thread specific context (or maybe even just reference the system.web and access the current session state) and have the entities themselves always pull these variables to then call the stored procudure before issuing the actual save sql that I would need to have happen within the same transaction scope.

What would be the best way to tackle this?

Derive from the DataAccessAdapter and override SaveEntity().

Sorry, forgot to mention, using SelfServicing.

Then override Save(IPredicate updateRestriction, bool recurse) in a partial class of the entity or if you're using two-class scenario, override it there .