Devart Forums

            using (var scope = new System.Transactions.TransactionScope())
            {
                var codeVersion = new EntityCodesVersion();
                codeVersion.DateImport = DateTime.Now;
                codeVersion.Version = "8.0";

                using (DatabaseManagerDbContext context = ADatabaseManagerFactory.Instance.CreateDatabaseManagerDbContext())
                {
                    context.CodesVersions.Add(codeVersion);
                    bool bOKSave = context.SaveChanges() > 0;
                }
                scope.Complete();
            }

1. Editing postgresql.conf and activate option max_prepared_transactions to 5
2. If I put PgSqlConnectionStringBuilder.Enlist = false :
   When context.SaveChanges() is run, the EntityCodesVersion record is written into database. It should not be written into database because It is done into a TransactionScope scope !
   So, the scope.Complete() done nothing more because the record is already written into database.
3. If I put PgSqlConnectionStringBuilder.Enlist = true : Two things :
   1. When open trigger on table notifications, I have exception :

      Exception (TransactionAbordedException) The transaction has been interrupted.
      1.inner Exception : cannot execute PREPARE on transaction that have execute LISTEN, UNLISTEN or NOTIFY.

   2. When SaveChange is executed : the record is not written into database (normal way), when scope.Complete is executed, nothing is done (not normal, it must be written into database). When goes out of the transaction, an exception is raised : TransactionAbordedException with same error.

Feneck91 wrote:2. If I put PgSqlConnectionStringBuilder.Enlist = false :
When context.SaveChanges() is run, the EntityCodesVersion record is written into database. It should not be written into database because It is done into a TransactionScope scope !
So, the scope.Complete() done nothing more because the record is already written into database.

Feneck91 wrote:3. If I put PgSqlConnectionStringBuilder.Enlist = true : Two things :

1. When open trigger on table notifications, I have exception :

   Exception (TransactionAbordedException) The transaction has been interrupted.
   1.inner Exception : cannot execute PREPARE on transaction that have execute LISTEN, UNLISTEN or NOTIFY.

2. When SaveChange is executed : the record is not written into database (normal way), when scope.Complete is executed, nothing is done (not normal, it must be written into database). When goes out of the transaction, an exception is raised : TransactionAbordedException with same error.

I have tried to make Connection.EnlistTransaction(System.Transactions.Transaction.Current); but same problems.

• I use triggers to be notified when the database is changed. The triggers use NOTIFY command to notify changes.
• I use TransactionScope to make transactions.

• PgSqlConnectionStringBuilder.Enlist = true; to make auto add connections to current trnsaction
• And, the error : PgSqlConnectionStringBuilder.TransactionScopeLocal = true; to say to PostgreSQL that don't use PREPARE TRANSACTION but just do a simple transaction.