transactionscope Questions

6

Solved

I am building my own custom repository, based on entity framework, and I'm creating some extension methods that allow me to save partial view models as entity models so I'm building my own Add and ...
Wile asked 26/10, 2012 at 7:14

0

I read this topics: SQL Server 2014 reseting isolation level How do I unset/reset a transaction isolation level for SQL Server? KB3025845 - FIX: The transaction isolation level is reset incorrectly...

11

Solved

I am getting the following error when I try to call a stored procedure that contains a SELECT Statement: The operation is not valid for the state of the transaction Here is the structure of my...
Coniine asked 10/10, 2008 at 21:49

10

Solved

I have a long running TransactionScope in C#. I told the scope that it should have a long timespan, but still I get a timeout. What could cause this? TransactionOptions transactionOptions = new Tr...
Arvonio asked 21/8, 2012 at 13:5

2

Solved

I can't find any information on this anywhere and yet the question is simple. Can I wrap storage-related actions in a TransactionScope such that e.g. if there is a rollback, the uploaded file is r...
Cafeteria asked 4/8, 2013 at 17:20

1

Solved

My application using Azure SQL and Azure Blob Storage for some business requirements, most of the case need to support Atomic Transaction for both DB & Blob, if DB entry fails should rollback B...
Spume asked 18/10, 2022 at 15:12

5

Solved

This question is related to my question: SQL Server and TransactionScope (with MSDTC): Sporadically can't get connection I'm doing some transaction programming using the .net TransactionScope ...
Atiptoe asked 21/6, 2010 at 14:36

3

Solved

When Method1() instantiates a TransactionScope and calls Method2() that also instantiates a TransactionScope, how does .NET know both are in the same scope? I believe it doesn't use static methods ...
Binah asked 5/8, 2010 at 18:22

5

Having this strange behavior while using OracleConnection with TransactionScope. If i try to use connection.BeginTransaction() in a transaction scope i get simple elegant InvalidOperationException...
Pennant asked 29/7, 2011 at 9:3

1

Solved

Short Version How do i enlist in an ongoing TransactionScope? Long Version If you use a TransactionScope, you can create an "ambient" transaction: using (TransactionScope scope = new Tran...
Oust asked 12/11, 2021 at 14:10

3

Solved

What I can't understand is if its possible to make changes to the context and get the changes in the same transaction before its commited. This is what I´m looking for: using (var scope = new Tra...

4

I'm trying to integrate async/await into our service bus. I implemented a SingleThreadSynchronizationContext based on this example http://blogs.msdn.com/b/pfxteam/archive/2012/01/20/10259049.aspx. ...
Atmosphere asked 24/11, 2012 at 16:47

2

Solved

When i create a TransactionScope object as followed: using (TransactionScope ts = new TransactionScope()) { // Do stuff... } What is the default transaction timeout of the given ts object?
Coexist asked 26/11, 2013 at 18:10

2

Solved

According to Microsoft documentation: TransactionScope.Complete is merely a way of informing the transaction manager of your status, the actual work of committing the transaction by the transactio...
Illuminati asked 21/5, 2021 at 9:36

3

Solved

I have two transaction scopes, one within another. I would love to know if the inner transaction scope will be rolled back after it has been committed and the outer one does not complete.
Arta asked 21/12, 2010 at 9:44

2

Solved

What is the difference between System.Transactions.TransactionScope and EF6's Database.BeginTransaction? Could someone give a small example or just explain which one to use when with a clear...

1

In windows azure we have hosted two asp.net webapi project as app service. We need to enable distributed transaction here. We initiate transaction inside one api. Then inside that transaction scope...

3

Solved

I have been working on a winform app with Oracle 10g database which is using TransactionScope and wanted to modify the maxTimeOut value specified in machine.config file, my machine.config file is i...
Conversant asked 29/4, 2013 at 14:27

3

Solved

What is the best way to know if the code block is inside TransactionScope? Is Transaction.Current a realiable way to do it or there are any subtleties? Is it possible to access internal ContextData...
Dissimilarity asked 11/6, 2009 at 10:14

10

Solved

I'm using SQL Server and ASP.NET. I have the following function: Using js = daoFactory.CreateJoinScope() Using tran = New Transactions.TransactionScope() '... tran.Complete() End Using End Usin...
Retinite asked 12/4, 2012 at 19:53

4

Solved

As demonstrated by previous Stack Overflow questions (TransactionScope and Connection Pooling and How does SqlConnection manage IsolationLevel?), the transaction isolation level leaks across pooled...
Giaour asked 24/3, 2012 at 11:38

3

Solved

I have a method similar to: public async Task SaveItemsAsync(IEnumerable<MyItem> items) { using (var ts = new TransactionScope()) { foreach (var item in items) { await _repository...
Fettle asked 6/7, 2014 at 5:46

4

Solved

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 wrapped in one transaction, and one dbconte...
Autotoxin asked 18/1, 2014 at 10:40

2

Solved

As many knows, TransactionScope were forgotten when the async await pattern was introduced in .Net. They were broken if we were trying to use some await call inside a transaction scope. Now this i...
Stendhal asked 24/5, 2017 at 13:35

4

Solved

Under what circumstances can code wrapped in a System.Transactions.TransactionScope still commit, even though an exception was thrown and the outermost scope never had commit called? There is a to...
Quip asked 10/11, 2009 at 12:21

© 2022 - 2025 — McMap. All rights reserved.