List (known) providers that support system.transactions & ambient

It would be really helpful to provide a list of which providers you know of that can support system.transactions and more importantly transactionscope. It's a pain to have to find out the hard way and it's not obvious anywhere. E.g. I got the ambient not supported exception with Sqlite and the only other evidence I could find was looking in the github repo and seeing that the code throws that error. So then I read up on Sqlite and TScope to learn more. It supports system.transactions (commitable works), but not TScope. Would be great to have as many as you know listed here and have the provider writers continue to help add that detail (or links) to this doc. Thanks!

---
#### Document Details

⚠ *Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.*

* ID: 1073c238-9389-d826-a696-f1108a4f2ce0
* Version Independent ID: cf56babd-def0-d76e-8eee-e33341b6a009
* Content: [Transactions - EF Core](https://docs.microsoft.com/en-us/ef/core/saving/transactions)
* Content Source: [entity-framework/core/saving/transactions.md](https://github.com/aspnet/EntityFramework.Docs/blob/master/entity-framework/core/saving/transactions.md)
* Product: **entity-framework**
* GitHub Login: @rowanmiller
* Microsoft Alias: **divega**