Answered by:
.NET Core supporting distributed transactions

Question
-
Hello, everyone.
I have a .NET Core app that connects to several Oracle databases using ODP.NET Core. I want to know if .NET Core supports distributed transactions for Oracle or even SQL Server.
Thanks in advanced.
Geraldo Peralta
Wednesday, December 25, 2019 11:09 PM
Answers
-
Hi Geraldo17,
Thank you for posting here.
Based on my search, it seems that .NET Core does not support distributed transactions now.
Best Regards,
Timon
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.- Edited by Timon YangMicrosoft contingent staff Thursday, December 26, 2019 3:28 AM
- Proposed as answer by CoolDadTx Saturday, December 28, 2019 4:11 PM
- Marked as answer by Alberto PoblacionMVP Saturday, February 8, 2020 4:34 PM
Thursday, December 26, 2019 3:27 AM -
.NET Core doesn't support Distributed Transactions because it would require a different transaction manager for each platform.
However if you use Entity Framework Core targeting the full .NET Framework, the implementation of System.Transactions there does support distributed transactions.
william xifaras
- Edited by William Xifaras Friday, December 27, 2019 1:32 PM
- Proposed as answer by CoolDadTx Saturday, December 28, 2019 4:12 PM
- Marked as answer by Alberto PoblacionMVP Saturday, February 8, 2020 4:34 PM
Friday, December 27, 2019 1:31 PM
All replies
-
You may have to verify it, but EF Core supports distributed transactions. Nothing else like the System.Transaction namepaces and MSDTC is supported in Core. You may want to ask is some database forums.
Wednesday, December 25, 2019 11:34 PM -
Hi Geraldo17,
Thank you for posting here.
Based on my search, it seems that .NET Core does not support distributed transactions now.
Best Regards,
Timon
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.- Edited by Timon YangMicrosoft contingent staff Thursday, December 26, 2019 3:28 AM
- Proposed as answer by CoolDadTx Saturday, December 28, 2019 4:11 PM
- Marked as answer by Alberto PoblacionMVP Saturday, February 8, 2020 4:34 PM
Thursday, December 26, 2019 3:27 AM -
.NET Core doesn't support Distributed Transactions because it would require a different transaction manager for each platform.
However if you use Entity Framework Core targeting the full .NET Framework, the implementation of System.Transactions there does support distributed transactions.
william xifaras
- Edited by William Xifaras Friday, December 27, 2019 1:32 PM
- Proposed as answer by CoolDadTx Saturday, December 28, 2019 4:12 PM
- Marked as answer by Alberto PoblacionMVP Saturday, February 8, 2020 4:34 PM
Friday, December 27, 2019 1:31 PM -
Hi
Is your problem solved? If so, please post "Mark as answer" to the appropriate answer. So that it will help other members to find the solution quickly if they face the similar issue.
Best Regards,
Jack
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.Tuesday, January 7, 2020 9:02 AM