tagged [transactionscope]
TransactionScope not rolling back transaction
TransactionScope not rolling back transaction Here is the current architecture of my transaction scope source code. The third insert throws an .NET exception (Not a SQL Exception) and it is not rollin...
- Modified
- 4 Dec at 16:31
TransactionScope Prematurely Completed
TransactionScope Prematurely Completed I have a block of code that runs within a TransactionScope and within this block of code I make several calls to the DB. Selects, Updates, Creates, and Deletes, ...
- Modified
- 25 Apr at 18:15
SQLTransaction has completed error
SQLTransaction has completed error I got following error once in my application. > This SQLTransaction has completed; it is no longer usable Stack Trace is attached below – It says about `Zombie Check...
- Modified
- 23 May at 11:47
Using TransactionScope around a stored procedure with transaction in SQL Server 2014
Using TransactionScope around a stored procedure with transaction in SQL Server 2014 I am using C# and ADO.Net with a `TransactionScope` to run a transaction in an ASP.Net app. This transaction is sup...
- Modified
- 15 Jul at 05:4
Why doesn't TransactionScope work with Entity Framework?
Why doesn't TransactionScope work with Entity Framework? See the code below. If I initialize more than one entity context, then I get the following exception on the . If I comment out the second set i...
- Modified
- 23 May at 10:34
How does TransactionScope roll back transactions?
How does TransactionScope roll back transactions? I'm writing an integration test where I will be inserting a number of objects into a database and then checking to make sure whether my method retriev...
- Modified
- 31 Jan at 09:52
TransactionScope: Avoiding Distributed Transactions
TransactionScope: Avoiding Distributed Transactions I have a parent object (part of a DAL) that contains, amongst other things, a collection (`List`) of child objects. When I'm saving the object back ...
- Modified
- 13 Jun at 10:53
Why is TransactionScope operation is not valid?
Why is TransactionScope operation is not valid? I have a routine which uses a recursive loop to insert items into a SQL Server 2005 database The first call which initiates the loop is enclosed within ...
- Modified
- 23 Mar at 19:49
Ignore TransactionScope for specific query
Ignore TransactionScope for specific query I'm looking for a way to execute a query while a TransactionScope is alive, and ignore the TransactionScope - basically, I want to execute this particular qu...
- Modified
- 3 Apr at 06:38
One transaction with multiple dbcontexts
One transaction with multiple dbcontexts I am using transactions in my unit tests to roll back changes. The unit test uses a dbcontext, and the service i'm testing uses his own. Both of them are wrapp...
- Modified
- 18 Jan at 10:40
TransactionScope maximumTimeout
TransactionScope maximumTimeout I use TransactionScope in this code: ``` private void ExecuteSP() { bool IsComplete = false; SqlCommand sqlComm = null; //6 hours!!! TimeSpan ts1 = new TimeSpan...
- Modified
- 3 May at 00:40
Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction? What does it mean for an SqlConnection to be "enlisted" in a transaction? Does it simply...
- Modified
- 7 Dec at 21:59
How to support async methods in a TransactionScope with Microsoft.Bcl.Async in .NET 4.0?
How to support async methods in a TransactionScope with Microsoft.Bcl.Async in .NET 4.0? I have a method similar to: ``` public async Task SaveItemsAsync(IEnumerable items) { using (var ts = new Tra...
- Modified
- 10 Jan at 17:25
Asynchronously commit or rollback a transaction scope
Asynchronously commit or rollback a transaction scope As many knows, `TransactionScope` were forgotten when the `async` `await` pattern was introduced in .Net. They were broken if we were trying to us...
- Modified
- 17 Mar at 18:51
Why am I getting this error suddenly?
Why am I getting this error suddenly? So I have a WCF service, inside which there's a Process() method. This method reads a byte array (a file) from one table, and basically puts that data from that f...
- Modified
- 23 May at 11:54
TransactionScope TransactionAborted Exception - transaction not rolled back. Should it be?
TransactionScope TransactionAborted Exception - transaction not rolled back. Should it be? (SQL SERVER 2008) If a Transaction Timeout error occurs within a TransactionScope (.Complete()) would you exp...
- Modified
- 21 Jan at 14:5
Entity Framework 6 async operations and TranscationScope
Entity Framework 6 async operations and TranscationScope I search on stackoverflow but could not find a similar question, please point me if there is already one. I was trying to implement a generic r...
- Modified
- 20 Jun at 09:12
TransactionScope - The underlying provider failed on EnlistTransaction. MSDTC being aborted
TransactionScope - The underlying provider failed on EnlistTransaction. MSDTC being aborted Our team have got a problem that manifests as: > The underlying provider failed on EnlistTransaction; Cannot...
- Modified
- 28 Jul at 10:25
TransactionScope automatically escalating to MSDTC on some machines?
TransactionScope automatically escalating to MSDTC on some machines? In our project we're using TransactionScope's to ensure our data access layer performs it's actions in a transaction. We're aiming ...
- Modified
- 23 May at 11:33