Set Command Timeout in entity framework 4.3

Question

I cannot find the a way to set the command timeout of a linq query using entity framework 4.3 and its' DbContext. How do I increase Commandtimeout in entity framework?

EDIT I am actually looking for Command Timeout increase. I confused the two, it is the sql command that is timing out not the connection.

Thanks

For newer EF versions, see: stackoverflow.com/a/6234593/12484 — Jon Schneider
– Jon Schneider, Commented Apr 8, 2015 at 16:04

Saher Ahwal · Accepted Answer · 2012-07-31 20:53:37Z

64

If you're using DbContext, you'll first need to drop down to ObjectContext:

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

edited Jul 31, 2012 at 20:53

Saher Ahwal

9,26733 gold badges91 silver badges156 bronze badges

answered Jul 31, 2012 at 20:13

bricelam

30.7k9 gold badges97 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Saher Ahwal Over a year ago

Edited my question : I confused command and connect timeout. Sorry

dilipkumar1007 Over a year ago

will you please suggest me where we should we have to apply this code in our project ???

Maurice Jordan · Accepted Answer · 2015-01-06 15:02:13Z

11

I added the command timeout value in my Context class in an attempt to handle longer processing times for some of the stored procedures that are populating my application. Seems to have done the trick.

public partial class ExampleEntities : DbContext
    {
        public ExampleEntities()
            : base("name=ExampleEntities")
        {
            ((IObjectContextAdapter)this).ObjectContext.CommandTimeout = 180;
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }

answered Jan 6, 2015 at 15:02

Maurice Jordan

1111 silver badge3 bronze badges

2 Comments

sapatelbaps Over a year ago

Perfect answer with sample code where to put. Thanks.

Tim Sparkles Over a year ago

Note that since this class is usually generated code, it would probably be better to make this change in the .tt file or some other initialization code. Otherwise the change will get clobbered next time you update the data model and regenerate.

m-Abrontan · Accepted Answer · 2013-06-30 12:48:37Z

9

this command is enough.

((System.Data.Entity.Infrastructure.IObjectContextAdapter) context).ObjectContext.CommandTimeout
                = 180;

answered Jun 30, 2013 at 12:48

m-Abrontan

5034 silver badges8 bronze badges

1 Comment

dilipkumar1007 Over a year ago

will you please suggest me where we should we have to apply this code in our project ???

Collectives™ on Stack Overflow

Set Command Timeout in entity framework 4.3

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related