我的命令一直超时,所以我需要更改默认的命令超时值.
我找到了myDb.Database.Connection.ConnectionTimeout
个,但是readonly
个.
How can I set the command timeout in Entity Framework 5 ?
我的命令一直超时,所以我需要更改默认的命令超时值.
我找到了myDb.Database.Connection.ConnectionTimeout
个,但是readonly
个.
How can I set the command timeout in Entity Framework 5 ?
在你的语境中试试这个:
public class MyDatabase : DbContext
{
public MyDatabase ()
: base(ContextHelper.CreateConnection("Connection string"), true)
{
((IObjectContextAdapter)this).ObjectContext.CommandTimeout = 180; // seconds
}
}
如果要在连接字符串中定义超时,请使用如下连接字符串中的Connection Timeout
参数:
<connectionStrings>
<add name="AdventureWorksEntities"
connectionString="metadata=.\AdventureWorks.csdl|.\AdventureWorks.ssdl|.\AdventureWorks.msl;
provider=System.Data.SqlClient;provider connection string='Data Source=localhost;
Initial Catalog=AdventureWorks;Integrated Security=True;Connection Timeout=60;
multipleactiveresultsets=true'" providerName="System.Data.EntityClient" />
</connectionStrings>