Problem with TransactionScopeOption.Suppress
Posted: Mon 03 Oct 2011 15:20
I am using the System.Transactions Namespace but I need one table operation out of the transaction, so I defined a TransactionScope for it and set its TransactionScopeOption parameter to "Suppress" but it seems it does not work. Such a table is a PostgreSQL table used to insert logging data. I am throwing an exception in order to test this situation. After the process is finished, the tables involved in the transaction do not contain any records and the logging table does not have any new record added either. The logging table inserts a new record everytime an exception is thrown. Is there any issue supporting TransactionScopeOption.Suppress?
I am using dotConnect for PostgreSQL v5.10.111.0 and PostgreSQL v9.0.
Regards,
Jorge Maldonado
I am using dotConnect for PostgreSQL v5.10.111.0 and PostgreSQL v9.0.
Regards,
Jorge Maldonado