Set database timeout in Entity Framework

Question

My command keeps timing out  so I need to change the default command timeout value   I ve found myDb Database Connection ConnectionTimeout  but it s readonly   How can I set the command timeout in Entity Framework 5

User · Answer

You can use DbContext Database CommandTimeout   180     seconds It s pretty simple and no cast required

User · Answer

I just ran in to this problem and resolved it by updating my application configuration file  For the connection in question  specify  Connection Timeout 60   I am using entity framework version 5 0 0 0   ConnectionTimeout Setting

User · Answer

Same as other answers  but as an extension method   static class Extensions       public static void SetCommandTimeout this IObjectContextAdapter db  TimeSpan  timeout                db ObjectContext CommandTimeout   timeout HasValue    int   timeout Value TotalSeconds   null

User · Answer

I extended Ronnie s answer with a fluent implementation so you can use it like so   dm Context SetCommandTimeout 120  Database SqlQuery     public static class EF       public static DbContext SetCommandTimeout this DbContext db  TimeSpan  timeout                  IObjectContextAdapter db  ObjectContext CommandTimeout   timeout HasValue    int   timeout Value TotalSeconds   null           return db             public static DbContext SetCommandTimeout this DbContext db  int seconds                return db SetCommandTimeout TimeSpan FromSeconds seconds

User · Answer

For Database first Aproach   We can still set it in a constructor  by override the ContextName Context tt T4 Template this way    lt   Accessibility ForType container   gt  partial class  lt   code Escape container   gt    DbContext       public  lt   code Escape container   gt              base  name  lt   container Name  gt                  Database CommandTimeout   180   lt   if   loader IsLazyLoadingEnabled container       gt          this Configuration LazyLoadingEnabled   false   lt       Database CommandTimeout   180  is the acutaly change   The generated output is this   public ContextName     base  name ContextName         Database CommandTimeout   180      If you change your Database Model  this template stays  but the actualy class will be updated

User · Answer

You can use this simple  dbContext Database SetCommandTimeout 300

User · Answer

Try this on your context  public class MyDatabase   DbContext       public MyDatabase              base ContextHelper CreateConnection  quot Connection string quot    true                  IObjectContextAdapter this  ObjectContext CommandTimeout   180     seconds           If you want to define the timeout in the connection string  use the Connection Timeout parameter like in the following connection string   lt connectionStrings gt    lt add name  quot AdventureWorksEntities quot  connectionString  quot metadata   AdventureWorks csdl   AdventureWorks ssdl   AdventureWorks msl  provider System Data SqlClient provider connection string  Data Source localhost  Initial Catalog AdventureWorks Integrated Security True Connection Timeout 60  multipleactiveresultsets true  quot  providerName  quot System Data EntityClient quot    gt    lt  connectionStrings gt   Source  How to  Define the Connection String

User · Answer

My partial context looks like   public partial class MyContext   DbContext       public MyContext  string ConnectionString            base ConnectionString                this SetCommandTimeOut 300              public void SetCommandTimeOut int Timeout                var objectContext    this as IObjectContextAdapter  ObjectContext          objectContext CommandTimeout   Timeout            I left SetCommandTimeOut public so only the routines I need to take a long time  more than 5 minutes  I modify instead of a global timeout

User · Answer

In the generated constructor code it should call OnContextCreated    I added this partial class to solve the problem   partial class MyContext  ObjectContext       partial void OnContextCreated                 this CommandTimeout   300

[c#] Set database timeout in Entity Framework

Examples related to c#

Examples related to .net

Examples related to asp.net-mvc

Examples related to entity-framework

Examples related to connection-timeout