Set Command Timeout in entity framework 4.3

c# .net entity-framework entity-framework-4.3 command-timeout
Saher Ahwal picture Saher Ahwal · Jul 31, 2012 · Viewed 33.8k times · Source

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

Answer

bricelam picture bricelam · Jul 31, 2012

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

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

Related questions

What difference does .AsNoTracking() make?

I have a question regarding the .AsNoTracking() extension, as this is all quite new and quite confusing. I'm using a per-request context for a website. A lot of my entities don't change so don't need to be tracked, but I …

Read More
How to fix: The number of properties in the Dependent and Principal Roles in a relationship constraint must be identical?

I am using Entity Framework 4.3.1 against a SQL Server 2012 database and I am using the POCO approach. I am getting the following error and I am wondering if anyone can explain how to fix it: ModelValidationException One or more validation …

Read More
How can I disable model compatibility checking in Entity Framework 4.3?

I'm working with EF 4.3 and have a context which needs to talk to a database which was generated by another library using EF Code First 4.3. The context is throwing an exception stating The model backing the 'Context' context has changed …

Read More