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

Interlining

For newer EF versions, see: https://mcmap.net/q/86651/-entity-framework-timeouts – Anatomist

Answer 1

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

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

Bombay

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

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

Answer 2

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();
        }

Tice

Perfect answer with sample code where to put. Thanks. – Gadoid

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. – Maytime

Answer 3

this command is enough.

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

Lanceolate

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