locked
.NET Core supporting distributed transactions RRS feed

  • 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

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.

    Transactionscope throwing exception this platform does not support distributed transactions while opening connection object

    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.


    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.

    Distributed Transactions


    william xifaras


    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