Entity Framework and connection string max Timeouts

5.1k views Asked by At

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>
1

There are 1 answers

0
user2700840 On BEST ANSWER

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