Using inside a TransactionScope throws "Specified method is not supported"

[lawrenceshort]

When using a DataContext inside a TransactionScope a "Specified Method is not supported" exception is thrown at the System.Data.Common.DbConnection.EnlistTransaction stage.

[lawrenceshort]

This can be fixed by including the System.Transactions reference and overriding the EnlistTransaction method in ReliableSqlDbConnection as below

    public override void EnlistTransaction(Transaction transaction)
    {
        ReliableConnection.Current.EnlistTransaction(transaction);
    }

Transactions inside a TransactionScope then function perfectly.

[robdmoore]

Nice! Do you mind submitting a pull request along with a test?

On 24 Feb 2016, at 1:17 am, lawrenceshort [email protected] wrote:

This can be fixed by including the System.Transactions reference and overriding the EnlistTransaction method in ReliableSqlDbConnection as below

public override void EnlistTransaction(Transaction transaction)
{
    ReliableConnection.Current.EnlistTransaction(transaction);
}

Transactions inside a TransactionScope then function perfectly.

—
Reply to this email directly or view it on GitHub.

[psheldon]

Is it possible to get the NuGet package update with this fix? I've installed the package that has the transient fault handling library ILMerged into it, and I'm getting this same exception as above.

[robdmoore]

More than happy for anyone to submit a PR

[psheldon]

Hi Rob Not sure this is about a PR, but rather than a PR was created back in 2016 but the Nuget package doesn't reflect that change. Cheers Paul (also in Perth!)

…

________________________________ From: Rob Moore [[email protected]] Sent: Tuesday, 5 September 2017 11:27 AM To: MRCollective/ReliableDbProvider Cc: Paul Sheldon; Comment Subject: Re: [MRCollective/ReliableDbProvider] Using inside a TransactionScope throws "Specified method is not supported" (#16) More than happy for anyone to submit a PR — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#16 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AEHciRM-pgBcUfIYEp1hhNi9ScnS8UErks5sfL-YgaJpZM4Hgfg1>.

[robdmoore]

AH, so it was - sorry.

Looks like tests are failing on that. Not sure if it's the build server or the code itself.