Using ConnectionProvider instead of Connection everywhere for database compatibility (transactions) and better use of the connection pool.
All tests passing for SqlServer