Verify that distributed transactions are working on .NET 7

[bording]

.NET 7 has added support for distributed transactions when running on Windows.

We should enable our TransactionScope tests for .NET 7 / Windows to verify that everything is working correctly.

Once that is done, we should update our transaction docs to reflect these changes.

[andreasohlund]

@bording #1243 proves that they work, lets close this one?

[bording]

Might be a good idea to leave this open until documentation is changed? We could also update the docs to explain how it would be possible to use with the existing packages by adding TransactionManager.ImplicitDistributedTransactions = true in a project.

[andreasohlund]

Turns out that a bug that we found and MS fixed in the .netframework driver didn't get ported to the .net version of the driver and is now blocking us from supporting transaction scopes with DTC. Note that transaction scopes do work and its just when escalating to DTC the mentioned deadlock happens.

@danielmarbach has submitted a PR to fix this and once merged and released we can proceed with this

[SimonCropp]

there is a preview nuget with @danielmarbach fix if u want to test it

[SimonCropp]

i tested in Nsb.Attachments and it worked

[bording]

DTC tests are passing in #1267

[danielmarbach]

5.1.4 of the MS data client contains the fix that I contributed

[andreasohlund]

It's been applied, should we close this one?