asp.net-mvcentity-frameworkentity-framework-6command-timeout

Set Command Timeout in EF 6

I want to set command timeout for query execution, currently I am doing context.Database.CommandTimeout = 90; but i feel this is not working, I tried checking the process logs in database but found the time difference was always less than 90sec.

Can someone help how can I set the database timeout in Entity Framework 6?

Solution

  • Check this :

    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;