The default behavior about auto-enlistment is usually to have it enabled by default. From Msdn:
> Automatic enlistment is the default (and preferred) way of integrating ADO.NET connections with System.Transactions.
This behavior is followed by SqlConnection, SQLiteConnection, SqlCeConnection, OdbcConnection, OracleConnection (managed & unmanaged), and MySqlConnection. NpgsqlConnection does not enable it by default up to its 3.2 version but has changed that in its code base for the 3.3 version of Npgsql ( https://github.com/npgsql/npgsql/issues/1483
Not having this enabled by default is unexpected for developers used to almost any other database.
But before enabling it by default, it will likely be required to do
, which is about another unexpected behavior which will not play very well with enabling auto-enlistment by default.