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: http://stackoverflow.com/a/6234593/12484 — Jon Schneider, Apr 08 '15 at 16:04

score 64 · Accepted Answer · edited Jul 31 '12 at 20:53

64

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

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

edited Jul 31 '12 at 20:53

Saher Ahwal

9,015
32
84
152

answered Jul 31 '12 at 20:13

bricelam

28,825
9
92
117

Edited my question : I confused command and connect timeout. Sorry – Saher Ahwal Jul 31 '12 at 20:18
will you please suggest me where we should we have to apply this code in our project ??? – dilipkumar1007 Dec 30 '14 at 10:15

score 11 · Answer 2 · answered Jan 06 '15 at 15:02

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 06 '15 at 15:02

Maurice Jordan

111
1
3

Perfect answer with sample code where to put. Thanks. – sapatelbaps Apr 07 '16 at 06:25
1

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. – Tim Sparkles Mar 19 '20 at 22:51

score 9 · Answer 3 · answered Jun 30 '13 at 12:48

9

this command is enough.

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

answered Jun 30 '13 at 12:48

m-Abrontan

503
4
7

will you please suggest me where we should we have to apply this code in our project ??? – dilipkumar1007 Dec 30 '14 at 10:16

Set Command Timeout in entity framework 4.3

3 Answers3

Linked