Npgsql.Tests.SystemTransactionTests.Rollback C# (CSharp) Method

        public void Rollback()
        {
            var connectionString = ConnectionString + ";enlist=true";
            using (var scope = new TransactionScope())
            using (var conn = new NpgsqlConnection(connectionString))
            {
                conn.Open();
                Assert.That(conn.ExecuteNonQuery(@"INSERT INTO data (name) VALUES('test')"), Is.EqualTo(1));
                // No commit
            }
            AssertNoPreparedTransactions();
            using (var conn = OpenConnection())
                Assert.That(conn.ExecuteScalar(@"SELECT COUNT(*) FROM data"), Is.EqualTo(0));
        }