learning transaction

[JHinW]

https://docs.microsoft.com/en-us/azure/service-fabric/service-fabric-reliable-services-reliable-collections-transactions-locks

[JHinW]

https://msdn.microsoft.com/en-us/ms172152

[JHinW]

https://github.com/dotnetcore/CAP/wiki/6.%E5%88%86%E5%B8%83%E5%BC%8F%E4%BA%8B%E5%8A%A1

[JHinW]

1. A common way an RM can work in cooperation with a TM within a transaction is what is commonly referred to as a two-phase commit process. The following is the typical flow of a two-phase commit:
2. link

Serializable:
Highest level of isolation. It locks data exclusively when read and write occurs. It acquires range locks so that phantom rows are not created.

Repeatable Read:
Second highest level of isolation. Same as serializable except it does not acquire range locks so phantom rows may be created.

Read Committed:
It allow shared locks and read only committed data. That means never read changed data that are in the middle of any transaction. Read Un-Committed:
It is the lowest level of Isolation. It allows dirty read.

[JHinW]

A. Implementing a Resource Manager Another link for learning

[JHinW]

=>

https://stackoverflow.com/questions/5265841/how-to-create-a-class-that-works-with-transactionscope

implement: => https://www.developer.com/net/net/article.php/3565196/SystemTransactions-Implement-Your-Own-Resource-Manager.htm

[JHinW]

check dbcontext transaction

https://stackoverflow.com/questions/34748872/how-to-check-whether-dbcontext-has-transaction

https://github.com/dotnet/corefx/issues/24282

https://coderwall.com/p/jnniww/why-you-shouldn-t-use-entity-framework-with-transactions

https://stackoverflow.com/questions/28191333/transactionscope-error-in-ambient-transaction-does-not-rollback-the-transaction