Linq2db queries should only use transactions for write queries (OSOE-343)

[Piedone]

As discussed at the Orchard meeting of 07.09.2021, for performance reasons linq2db queries shouldn't always open a transaction since for reads this is not necessary. Ideally, we'd have something like ITransactionManager.GetOrCreate() in Orchard or YesSql since YesSql opens transactions only the first time a write query happens, lazily.

See this discussion on what can be used from the linq2db API.

Jira issue

[hishamco]

linq2db never opens transaction without explicit request and we don't have any intentions to provide such opionated functionality.

While there's no plan in Linq2db, what's your suggestion here

[Piedone]

I don't have any specific suggestion; the implementation details are up to be figured out.