What is TransactionScope default Timeout value?

c# sql transactionscope
Uri Abramson picture Uri Abramson · Nov 26, 2013 · Viewed 22.2k times · Source

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?

Answer

David Pilkington picture David Pilkington · Nov 26, 2013

According to David Browne it is 1 minute

TransactionScope’s default constructor defaults the isolation level to Serializable and the timeout to 1 minute

using new TransactionScope() Considered Harmful

Related questions

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); try { using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew, ts1)) { using (SqlConnection sqlConn = new SqlConnection(GetConnectionString())) { //open sql connection sqlConn.Open(); …

Read More
What is the syntax for an inner join in LINQ to SQL?

I'm writing a LINQ to SQL statement, and I'm after the standard syntax for a normal inner join with an ON clause in C#. How do you represent the following in LINQ to SQL: select DealerContact.* from Dealer inner join …

Read More
Fastest Way of Inserting in Entity Framework

I'm looking for the fastest way of inserting into Entity Framework. I'm asking this because of the scenario where you have an active TransactionScope and the insertion is huge (4000+). It can potentially last more than 10 minutes (default timeout of transactions), …

Read More