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

Reputation: 426

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?

Upvotes: 27

Views: 41321

Answers (1)

Dilip Oganiya
Dilip Oganiya

Reputation: 1554

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;

Upvotes: 67

Related Questions