How to increase the Timeout session between Entity framework & Sql Server

Question

I am working on an entity framework inside asp.net mvc 5. and the sql server is very slow , so whenever i try to access a page that is connected to the Db i receive the following error:-

Server Error in '/' Application.
--------------------------------------------------------------------------------


The wait operation timed out 
  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

 Exception Details: System.ComponentModel.Win32Exception: The wait operation timed out

Source Error: 


 An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace:

but i can not find a way to increase the timeout inside my entity framework class ? My connection string inside web.config looks as follow:-

<add name="***Entities" connectionString="metadata=res://*/Models.Model2.csdl|res://*/Models.Model2.ssdl|res://*/Models.Model2.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=*******;initial catalog=TMSres;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

How to increase the Timeout session between Entity framework & Sql Server?

Thnaks

possible duplicate of Set database timeout in Entity Framework — usr
– usr, Commented Jun 22, 2014 at 14:20

Martijn Pieters · Accepted Answer · 2016-04-19 11:47:18Z

2

You can set it by

// Specify a timeout for queries in this context, in seconds.<br>
context.CommandTimeout = 120;

http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.commandtimeout(v=vs.110).aspx

edited Apr 19, 2016 at 11:47

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

answered Jun 22, 2014 at 14:41

Anshul Nigam

1,6281 gold badge12 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

How to increase the Timeout session between Entity framework & Sql Server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related