Entity Framework Timeouts

There is a known bug with specifying default command timeout within the EF connection string.

http://bugs.mysql.com/bug.php?id=56806

Remove the value from the connection string and set it on the data context object itself. This will work if you remove the conflicting value from the connection string.

Entity Framework Core:

this.context.Database.SetCommandTimeout(180);

Entity Framework 6:

this.context.Database.CommandTimeout = 180;

Entity Framework 5:

((IObjectContextAdapter)this.context).ObjectContext.CommandTimeout = 180;

Entity Framework 4 and below:

this.context.CommandTimeout = 180;

If you are using a DbContext, use the following constructor to set the command timeout:

public class MyContext : DbContext
{
 public MyContext ()
 {
 var adapter = (IObjectContextAdapter)this;
 var objectContext = adapter.ObjectContext;
 objectContext.CommandTimeout = 1 * 60; // value in seconds
 }
}

If you are using DbContext and EF v6+, alternatively you can use:

this.context.Database.CommandTimeout = 180;

If you are using Entity Framework like me, you should define Time out on Startup class as follows:

 services.AddDbContext<ApplicationDbContext>(
 options => options.UseSqlServer(
 Configuration.GetConnectionString("DefaultConnection"), 
 a => a.CommandTimeout(180)));

Usually I handle my operations within a transaction. As I've experienced, it is not enough to set the context command timeout, but the transaction needs a constructor with a timeout parameter. I had to set both time out values for it to work properly.

int? prevto = uow.Context.Database.CommandTimeout;
uow.Context.Database.CommandTimeout = 900;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromSeconds(900))) {
...
}

At the end of the function I set back the command timeout to the previous value in prevto.

Using EF6

I know this is very old thread running, but still EF has not fixed this. For people using auto-generated DbContext can use the following code to set the timeout manually.

public partial class SampleContext : DbContext
{
 public SampleContext()
 : base("name=SampleContext")
 {
 this.SetCommandTimeOut(180);
 }
 public void SetCommandTimeOut(int Timeout)
 {
 var objectContext = (this as IObjectContextAdapter).ObjectContext;
 objectContext.CommandTimeout = Timeout;
 }
}

In .NET Core use the following syntax to change the timeout from the default 30 seconds to 90 seconds:

public class DataContext : DbContext
{
 public DataContext(DbContextOptions<DataContext> options) : base(options)
 {
 this.Database.SetCommandTimeout(90); // <-- 90 seconds
 }
}

This is what I've fund out. Maybe it will help to someone:

So here we go:

If You use LINQ with EF looking for some exact elements contained in the list like this:

await context.MyObject1.Include("MyObject2").Where(t => IdList.Contains(t.MyObjectId)).ToListAsync();

everything is going fine until IdList contains more than one Id.

The "timeout" problem comes out if the list contains just one Id. To resolve the issue use if condition to check number of ids in IdList.

Example:

if (IdList.Count == 1)
{
 result = await entities. MyObject1.Include("MyObject2").Where(t => IdList.FirstOrDefault()==t. MyObjectId).ToListAsync();
}
else
{
 result = await entities. MyObject1.Include("MyObject2").Where(t => IdList.Contains(t. MyObjectId)).ToListAsync();
}

Explanation:

Simply try to use Sql Profiler and check the Select statement generated by Entity frameeork. ...

For Entity framework 6 I use this annotation and works fine.

 public partial class MyDbContext : DbContext
 {
 private const int TimeoutDuration = 300;
 public MyDbContext ()
 : base("name=Model1")
 {
 this.Database.CommandTimeout = TimeoutDuration;
 }
 // Some other codes
 }

The CommandTimeout parameter is a nullable integer that set timeout values as seconds, if you set null or don't set it will use default value of provider you use.

Adding the following to my stored procedure, solved the time out error by me:

SET NOCOUNT ON;
SET ARITHABORT ON;

• c#
• sql-server
• entity-framework
• entity-framework-4
• connection-string