Better explain the differences between ExecuteInTransaction and BeginTransaction

[wertzui]

The differences between ExecuteInTransaction (Async) and Begin-/Commit-/RollbackTransaction are not obvious and should be better explained.

See also https://learn.microsoft.com/en-us/dotnet/api/system.data.entity.database.begintransaction?view=entity-framework-6.2.0

---

Document Details

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

• ID: 1b3f7aa2-df0d-abe1-0c04-13e0fc07286c
• Version Independent ID: b62d9d58-7729-1ec0-70d8-f2491aa2d66b
• Content: ExecutionStrategyExtensions.ExecuteInTransactionAsync Method (Microsoft.EntityFrameworkCore)
• Content Source: dotnet/xml/Microsoft.EntityFrameworkCore/ExecutionStrategyExtensions.xml
• Product: ef-core-api
• GitHub Login: @dotnet-bot
• Microsoft Alias: avickers

[ajcvickers]

@wertzui You are commenting on the EF Core docs, but the link references EF6. Which are you using?

[wertzui]

Sorry, that was the wrong link.
I'm using EF Core.

This should be the correct link to the EF Core documentation
https://learn.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.infrastructure.databasefacade.begintransaction?view=efcore-6.0

[ajcvickers]

@wertzui Have you tried looking at the documentation on transactions and connection resiliency?

[wertzui]

Thanks for the links.
I think, https://learn.microsoft.com/en-us/ef/core/miscellaneous/connection-resiliency#option-3---add-state-verification explains it quite good.
However I was unable to find it myself so just some interlinking between the pages would help guide other people to the right documentation.