Feature Request: Distributed Transactions

[filgueirasfernando]

.NET added support for TransactionScope a few years ago. It’s a very important feature for enterprise apps and this lib don’t haves. If someone with this expertise can do the job, i will by thankfully!

Sorry for bad english :/

[ratacolita]

Hi @filgueirasfernando,

I've implemented TransactionScope support in PR #238. The implementation includes:

• IEnlistmentNotification implementation for two-phase commit protocol
• EnlistTransaction(Transaction) method for manual enlistment
• Auto-enlistment in Transaction.Current when Open() is called
• New Enlist connection string parameter to control auto-enlistment (default: true)

I could use some help with testing! I don't have access to a Sybase ASE database to test against. If anyone can test the following scenarios and report back, it would be very helpful:

1. Basic TransactionScope commit scenario
2. TransactionScope rollback (when Complete() is not called)
3. Multiple connections within the same TransactionScope
4. Enlist=false connection string to disable auto-enlistment

In the meantime, you can use the fork at https://github.com/acolita/AdoNetCore.AseClient (branch feature/transaction-scope-support) to try it out.

If this feature is useful to you, please give the PR a 👍 to help prioritize it!