Set Command Timeout in EF 6

Question

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?

Follow this post for more clarity: stackoverflow.com/questions/6232633/entity-framework-timeouts — Dilip Oganiya
– Dilip Oganiya, Commented May 2, 2016 at 9:11

er-sho · Accepted Answer · 2019-02-15 06:26:21Z

67

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;

edited Feb 15, 2019 at 6:26

er-sho

9,8212 gold badges16 silver badges26 bronze badges

answered May 2, 2016 at 9:10

Dilip Oganiya

1,55414 silver badges22 bronze badges

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

2 Comments

Zeek2 Over a year ago

Thanks. That fixed many occurrences of this build error for me: Upgrading from Entity Framework 5 to EF6 Error BC30456 "'CommandTimeout' is not a member of"

T M Over a year ago

For EF 6.2 at least this needs to be placed in Configuration class in the migrations folder in the constructor: public Configuration(){ CommandTimeout = 3600; }

Collectives™ on Stack Overflow

Set Command Timeout in EF 6

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related