Can you point to any open source projects or other examples implementing this pattern? I think I understand where you're coming from on this but I have not seen

Can you point to any open source projects or other examples implementing this pattern? I think I understand where you're coming from on this but I have not seen many examples of this approach in the wild (except religiously using TransactionScope, eg. http://amnesia.codeplex.com/ http://amnesia.codeplex.com/ ). I'm wondering where it's best to manage the transactions... would they ever be in raw SQL or stored procedures instead of .NET code?