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

by

.NET Core doesn’t support Distributed Transactions because it would require a different transaction manager on each platform. It may appear in the future (here‘s the issue in-progress), but for now any Transaction that would require two different resource managers will throw this exception.

Instead you can coordinate separate transactions. Have two separate transactions complete their work, and then commit them both. There is a possibility that the first commit succeeds and the second one fails, but for SQL Server (with one exception), that would be a very rare occurance. Something like:

_db1UOW.Begin(); //creating sql transaction
await _db1UOW.IDenialDetailsRepositorydb1.InsertDenialDetails(denialsDetails);
await _db1UOW.IRuleDetailsRepositorydb1.InsertRulesDetails(rulesDetails);

_db2UOW.Begin(); //creating sql transaction 
await _db2UOW.IRuleDetailsRepository.GetRulesDetails();
await _db2UOW.IDenialDetailsRepository.InsertDenialDetails(denialsDetails);
var data = await _db2UOW.IRuleDetailsRepository.InsertRulesDetails(rulesDetails);
 
_db1UOW.Commit(); //commitng sql transaction
try
{
    _db2UOW.Commit(); //commitng sql transaction
}
catch (Exception ex)
{
     LogError("Second transaction failed to commit after first one committed.  Administrators may need to fix stuff");
     throw;
}

Or if the two databases are on the same server you can use cross-database queries with a single SqlConnection to enlist the changes in a single SQL Server transaction.

More Related Contents:

  1. C#: SQL Server Connection String
  2. How to read AppSettings values from a .json file in ASP.NET Core
  3. Return file in ASP.Net Core Web API
  4. Return View as String in .NET Core
  5. SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
  6. Automatic native and managed DLLs extracting from Nuget Package
  7. Windows Forms Designer and WPF Designer for .NET Core
  8. Send HTTP POST message in ASP.NET Core using HttpClient PostAsJsonAsync
  9. Auto Versioning in Visual Studio 2017 (.NET Core)
  10. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  11. How to seed in Entity Framework Core 2?
  12. CORS in .NET Core
  13. Cross-platform file name handling in .NET Core
  14. Best way to share data between two child components in Blazor
  15. System.Text.Json – Deserialize nested object as string
  16. EF Core queries all columns in SQL when mapping to object in Select
  17. Setting the version number for .NET Core projects – CSPROJ – not JSON projects
  18. Add WHERE clauses to SQL dynamically / programmatically
  19. The parameterized query ….. expects the parameter ‘@units’, which was not supplied
  20. How do I reference a .NET Framework project in a .NET Core project?
  21. Query validation using C#
  22. Unable to connect to localDB in VS2012 – “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
  23. How to get nullable DateTime out of the database
  24. Fill DataTable asynchronously?
  25. Custom JSON serializer for optional property with System.Text.Json
  26. Refresh Token using Polly with Named Client
  27. How to set a global environment variable in .NET Core (user-wide or system-wide)
  28. Use SQL Server time datatype in C#.NET application?
  29. Filter Serilog logs to different sinks depending on context source?
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment