Top "Transactionscope" questions

TransactionScope is a .NET class used to mark a block of code as transactional.

TransactionScope maximumTimeout

I use TransactionScope in this code: private void ExecuteSP() { bool IsComplete = false; SqlCommand sqlComm = null; //6 hours!!! TimeSpan ts1 = new TimeSpan(6, 0, 0); …

c# sql stored-procedures app-config transactionscope
Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction

Just curious if anyone else has got this particular error and know how to solve it? The scenario is as …

asp.net sql transactions transactionscope msdtc
SQLTransaction has completed error

I got following error once in my application. This SQLTransaction has completed; it is no longer usable Stack Trace is …

c# .net ado.net transactionscope
What is the reason of "Transaction context in use by another session"

I'm looking for a description of the root of this error: "Transaction context in use by another session". I get …

.net sql-server transactions transactionscope
How to find the Transaction Status

I am using 'TransactionScope', and I need to just do some DML within the C# Code, which I have successfully. …

c# asp.net transactions transactionscope
C# controlling a transaction across multiple databases

Say I'm having a Windows Form application which connected to n databases, with n connections opened simultaneously. What I'm looking …

c# .net transactionscope
TransactionScope: Avoiding Distributed Transactions

I have a parent object (part of a DAL) that contains, amongst other things, a collection (List<t>) …

c# transactions transactionscope distributed-transactions
Will an inner transaction scope roll back if the outer transaction scope doesn't complete?

I have two transaction scopes, one within another. I would love to know if the inner transaction scope will be …

c# transactionscope
Refactoring ADO.NET - SqlTransaction vs. TransactionScope

I have "inherited" a little C# method that creates an ADO.NET SqlCommand object and loops over a list of …

sql-server ado.net transactions transactionscope
What is TransactionScope default Timeout value?

When i create a TransactionScope object as followed: using (TransactionScope ts = new TransactionScope()) { // Do stuff... } What is the default transaction …

c# sql transactionscope