Just read TransactionScope Implementations .
Can someone confirm if this method works on the client side .net or something special is required for specific database providers? Is this just SQL Server?
If your question also includes RDBMS providers, then SQL Server Compact supports it and Oracle.