How do you configure the Transaction time out in Entity Framework 6 DbContext.Database.BeginTransaction?

entity-framework transactions

Question

Using code like

using (var tran = Ctxt.Database.BeginTransaction()) {

How can I set a value for the transaction timeout ?

1
7
9/25/2014 4:05:40 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

If for whatever reason you need to manage transactions yourself it is much easier to use TransactionScope. It has several constructors accepting a TimeSpan parameter to set the timeout. For instance

using(var ts = new TransactionScope(TransactionScopeOption.Required,
                                    TimeSpan.FromMinutes(1)))
{
    using(var ctx = new MyContext())
    {
        // Do stuff.
    }
    ts.Complete(); // Try - catch to catch TimeoutException
}

I'm curious though why you want to set transaction timeout, not command timeout.

6
10/16/2013 6:49:02 PM

Related Questions

When doing many updates in Entity Framework 4, how do you avoid locking the database?

This question is in regards to the best practice for handling many inserts or updates using Microsoft Entity Framework. The problem is that we wrote a long-running program which pulls back thousands of records from the database, and then updates a single field on each of those records, one-by-one. Much to our dismay, we realized that each of these ...
c# entity-framework sql
asked by Grant Hughes

Connection closed when doing Transaction rollback on Mysql with Entity Framework 6 and Devart provider

I'm working on a project that uses Entity Framework 6 RC to connect to a Mysql database with the Devart provider(v7.8.322.0)....But now I run into a problem that when a query fails, the rollback of the transaction fails because the connection is closed....We are not starting any transactions ourselves....This is the stacktrace of the exception: ...
c# devart entity-framework-6 mysql transactions
asked by Steven Engels

Multiple database in one transaction in Entity Framework

I have created two different Contexts for two different databases in Entity Framework. Now I am trying to update these databases in single transaction. My code is like that:...public class LPO_BLL { internal Context1 _context1 = null; internal Context2 _Context2 = null; public LPO_Detail_BLL(Context1 context1, Context2 context2) { ...
.net asp.net c# entity-framework transactions
asked by Usman Khalid

Database.BeginTransaction vs Transactions.TransactionScope

I found out the answer in Entity Framework 6's documentation:...With the introduction of EF6, Microsoft recommends to use new API methods: ...Database.BeginTransaction()... and ...Database.UseTransaction().... Although ...System.Transactions.TransactionScope... is still very well supported, it is no longer ...necessary... for most users of EF6. ...
c# entity-framework entity-framework-6 transactions transactionscope
asked by Flair

Create a database relationship between 2 entities in different Entity Framework DbContexts

Yes, you are missing some points....The ...UserProfile... is a ...weak entity..., it is a dependant of ...Login.... The relationship is 1:1. 1 ...Login... has 1 ...UserProfile.......Your classes should be like this:...public class UserProfile { //UserProfile does not have its own Id, //Its Id is the LoginId, which is the primary key and a f...
c# entity-framework entity-framework-6
asked by Fabio Luz

`DbContext.Database.BeginTransaction` can't be nested?

Prior to EF6 the recommended way of providing larger scope transactions was to use a TransactionScope object, which still works, but seems to be deprecated (see ...here... - bottom of the page)
entity-framework entity-framework-6
asked by Neil

Entity Framework 6 Handle Transaction At Database Level

If anyone comes across this post and is wondering the answer is No!...context.Database.UseTransaction(null); ...Is not the same as using ...TransactionalBehavior.DoNotEnsureTransaction... on the ...ExecuteSqlCommand... overloaded method....However the following does work and can be used how I originally wanted:...((IObjectContextAdapter)_context).O...
c# entity-framework entity-framework-6 sql-server transactions
asked by Tom Maher

WinForms Entity Framework database connection exception at design-time

After re-installing Windows, SQL Server and Visual Studio, I got the same behaviour. After more searching it has become obvious that Visual Studio will always run a UserControl's ...Load... method at design-time when you add the UserControl to a form or open the designer of a form that contains the UserControl. The solution is to test the value of ...
c# design-time entity-framework-6 visual-studio-2017 winforms
asked by Matthew Bishop

Rollback additions / removals to DBSets of the DbContext using a transaction in Entity Framework

Option #1 from ...https://code.msdn.microsoft.com/How-to-undo-the-changes-in-00aed3c4... is typically enough for most implementations where you want to roll-back changes in the DbContext without dropping and re-instantiating a Context. Generally the request would have failed and the call would have ended so the DbContext scope should end until a re...
c# dbcontext entity-framework entity-framework-6
asked by Steve Py

How to edit 1000 records at time using entity framework in less time

public ActionResult EditRow() { using (SchoolContext db = new SchoolContext()) { var v = db.Students.ToList(); return View(v); } } [HttpPost] public ActionResult EditRow(List<Student> student) { if (ModelState.IsValid) { using (SchoolContext db = new SchoolContext()) ...
asp.net asp.net-mvc c# entity-framework entity-framework-6
asked by Codelover

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow