Update SQL Transport docs with partial DTC suppport in .NET 7

[MarcWils]

As of .NET 7 distributed transactions are supported on Windows (dotnet/runtime#715).

Docs could be updated on this part.

docs.particular.net/transports/sql/transactions_ambient-core-warning_sqltransport_[6,).partial.md

Line 13 in fe58f43

To resolve this, choose one of the other transaction modes. Support for `TransactionScope` is expected to be added in future releases of .NET Core.

[bording]

Hi @MarcWils,

Thanks for the suggestion.

We've got some work to do before we'd want to make changes to the docs, so I've gone ahead and opened Particular/NServiceBus.SqlServer#1145 to track that work.

Feel free to watch that issue for progress. I'm going to go ahead and close this issue for now.