Support for distributed transactions
Posted: Wed 03 Sep 2008 08:10
Hi,
Does the PostgreSQLDirect.NET provider support distributed transactions, automatically enlisting into existing transactions and thus taking part into distributed transactions with other providers (TransactionScope).
For instance:
using (TransactionScope scope = new TransactionScope())
{
// open a PostgreSQL Direct.NET connection here
// update some db data here
// if something fails here, exception is thrown, update db is rollbacked
scope.complete();
// transaction is committed only now !
}
Does the PostgreSQLDirect.NET provider support distributed transactions, automatically enlisting into existing transactions and thus taking part into distributed transactions with other providers (TransactionScope).
For instance:
using (TransactionScope scope = new TransactionScope())
{
// open a PostgreSQL Direct.NET connection here
// update some db data here
// if something fails here, exception is thrown, update db is rollbacked
scope.complete();
// transaction is committed only now !
}