Entity Framework and connection string max Timeouts

Question

I'm using a DbContext and want set CommandTimeout = 1 week. What is max timeout value for CommandTimeout?

((IObjectContextAdapter)this.context).ObjectContext.CommandTimeout = ?max?;

In connection string I also need set max time out value. What is max Connect Timeout value i can set?

<connectionStrings>
    <add name="TestEntities" connectionString="metadata=res://*/MyModel.csdl|res://*/MyModel.ssdl|res://*/MyModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.;initial catalog=DBTest;user id=sa;password=p/w; Connect Timeout=?max?; MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />    
  </connectionStrings>

This answer may be useful.

chridam
– chridam

2013-12-20 10:31:51 +00:00
Commented Dec 20, 2013 at 10:31 — chridam
– chridam, Commented Dec 20, 2013 at 10:31

user2700840 · Accepted Answer · 2013-12-20 15:30:48Z

1

A value of 0 indicates no limit (an attempt to execute a command will wait indefinitely). So 'indefinitely' is max value.

answered Dec 20, 2013 at 15:30

user2700840

4573 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework and connection string max Timeouts

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