I am pondering whether the using TransactionScope should be within a try..catch or the other way around. Within try..catch try { using (var scope = new TransactionScope()) { ...

After updating Spring.net packages from 2.0.2 to 3.0.2, it looks like something changed in the behavior of the [Transaction] attribute Interceptor, and now I'm getting an exception: System....

For a project I'm working on, I'd like to insert testdata before every test and then rollback the transaction for the next test to start with a clean slate. The skeleton code below works fine for that:...

I am working on a large-scale .NET test automation project (over 2500 test cases) that interacts with an application API. My goal is to keep the database clean and isolated between test runs. Here's ...

I am trying to use TransactionScope to make my db context operations spread across different files run under one transaction, so all or none save should happen. The problem is it is giving me this ...

Situation I have legacy .NET code in C# that needs to save a bunch of data with a transaction. This data is spread over multiple SQL Server databases. One database is connected directly with ...

I have a Azure function, which calls some API endpoint for database update/insert and then will complete the message in the Queue.In case azure functions code fails after API success, I want to ...

I am getting frequent deadlock in my appliation because The application has 50 to 60 screens we used SQL views for list screens we are using mainly only 2 tables which stores all the data and it has ...

I wrote an integration test to insert two documents with two threads simultaneously, after the test is completed, I expect none of the records inserted during the test exist in the database. I used ...

I'm currently looking at upgrading a .NET project (standard moving to .NET 8) that uses Entity Framework (v6.4.4) to EF Core (v8.0.8). For the most part the experience has been painless but I have one ...

Short version We want to disable the automatic enlistment to ambient transactions (System.Transactions.TransactionScope) for a whole Entity Framework Core 8 DbContext. The DbContext should never get ...

If I'm in the middle of doing a bunch of updates within a transaction, and it throws an exception, I still want to log some information in a table in the same db context so I know what happened. I ...

In ASP.NET Core 6.0, I am trying to update an Azure SQL database, and as well call a REST API for an external service, and if the external service call fails, I want to rollback the update. My code is ...

Here's my scenario: I have an extremely large table in Microsoft Access that I need to move to SQL Server. public async Task Sync() { using TransactionScope trans = new(TransactionScopeOption....

In Memory disk setup on SQL Server with below up snapshot_isolation_state snapshot_isolation_state_desc is_read_committed_snapshot_on is_memory_optimized_elevate_to_snapshot_on ...