blocks|key|763729|text|据我所知，没有全局设置命令超时属性的方法，您必须为创建的每个命令对象分别设置CommandTimeout属性。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|763730|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

As far as I know there is no global way of setting Command timeout property, you have to set CommandTimeout property individually for each command object you create.

blocks|key|764711|text|我是这样做的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|764712|private+readonly+MyDbContext+_context;

++++public+LinqToSql()+:+this(new+MyDbContext())
++++{
++++}

++++private+LinqToSql(MyDbContext+context)
++++{
++++++++_context+=+context;
++++++++_context.CommandTimeout+=+500;+

++++}|code-block|syntax|javascript|764713|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I made it like this:

<pre class="lang-cs prettyprint-override"><code>private readonly MyDbContext _context;

 public LinqToSql() : this(new MyDbContext())
 {
 }

 private LinqToSql(MyDbContext context)
 {
 _context = context;
 _context.CommandTimeout = 500; 

 }
</code></pre>

blocks|key|198485|text|可以在设置中设置超时，并在设置命令超时时引用该值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|198486|在appSettings下的配置中，为CommandTimeout添加一个键：|198487|<add+key="ContextCommandTimeout"+value="500"+/>|code-block|syntax|javascript|198488|然后在您的代码中：|198489|int+cmdTimeout+=+-1;
string+timeoutSettings+=+ConfigurationManager.AppSettings["ContextCommandTimeout"];

if(!string.IsNullOrEmpty(timeoutSettings))+
{
++++int.TryParse(timeoutSettings,+out+cmdTimeout);
}

if(cmdTimeout+>=0)
++++_context.CommandTimeout+=+cmdTimeout;+++++++|198490|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You can set the timeout in a setting and refer to that value when the command timeout is set. 
In config under appSettings add a key for CommandTimeout:

<pre class="lang-xml prettyprint-override"><code>&lt;add key="ContextCommandTimeout" value="500" /&gt;
</code></pre>

Then in your code:

<pre class="lang-cs prettyprint-override"><code>int cmdTimeout = -1;
string timeoutSettings = ConfigurationManager.AppSettings["ContextCommandTimeout"];

if(!string.IsNullOrEmpty(timeoutSettings)) 
{
 int.TryParse(timeoutSettings, out cmdTimeout);
}

if(cmdTimeout &gt;=0)
 _context.CommandTimeout = cmdTimeout; 
</code></pre>

blocks|key|2369916|text|如果您想将它放入您的web.config中，则需要添加一个空格。尝试：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2369917|Command+Timeout=60;|code-block|syntax|javascript|2369918|而不是：|2369919|CommandTimeout=60;|2369920|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

If you want to put it into your web.config, you need to add a space. Try:

<pre><code>Command Timeout=60;
</code></pre>

instead of:

<pre><code>CommandTimeout=60;
</code></pre>

blocks|key|763761|text|您可以在web.config文件中添加连接超时。将其设置为0，使其具有如下所示的无穷大。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|763762|Connection+Timeout=0;|code-block|syntax|javascript|763763|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can add connection time out in your web.config file.
Set it to 0 to have it infinite as below.

<pre><code>Connection Timeout=0;
</code></pre>

blocks|key|763794|text|假设这是一个.NET+web应用程序，因为它看起来像一个&它没有在描述/标记中指定。这对于我一直在开发的应用程序是有效的，将DB命令超时设置为15秒：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|763795|<connectionStrings>
++<add+name="ConnectionString"+
+++++++connectionString="Server=localhost;+Port=3306;+Database=<DB>;
+++++++++++++++++++++++++uid=<usr>;+pwd=<pw>;+default+command+timeout=15;"+
+++++++providerName="MySql.Data.MySqlClient"+/>
</connectionStrings>|code-block|syntax|javascript|763796|默认命令超时将应用程序范围应用于每个单独的DB请求。据我所知，如果没有指定，默认为30秒。。对于web应用程序来说，花费30秒以上的单个DB命令有点极端；重新考虑一下解决方案的架构可能会更好。|offset|length|763797|entityMap|0|LINK|mutability|MUTABLE|url|https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.commandtimeout?redirectedfrom=MSDN&view=netframework-4.8#System_Data_SqlClient_SqlCommand_CommandTimeout^0|0|0|V|E|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Going to assume this is a .NET web-app, since it looks like one &amp; it wasn't specified in the description / tags. This works for an app I've been developing, sets the DB command timeout to be 15 seconds:

<pre class="lang-xml prettyprint-override"><code>&lt;connectionStrings&gt;
 &lt;add name="ConnectionString" 
 connectionString="Server=localhost; Port=3306; Database=&lt;DB&gt;;
 uid=&lt;usr&gt;; pwd=&lt;pw&gt;; default command timeout=15;" 
 providerName="MySql.Data.MySqlClient" /&gt;
&lt;/connectionStrings&gt;
</code></pre>

The default command timeout is applied app-wide to each individual DB request. As far as I'm aware, <a href="https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.commandtimeout?redirectedfrom=MSDN&amp;view=netframework-4.8#System_Data_SqlClient_SqlCommand_CommandTimeout" rel="nofollow noreferrer">the default is 30 seconds if this isn't specified</a>. For a web-app, individual DB commands that take longer than 30 seconds is a bit extreme though; you may be better served having a rethink of how you architected the solution.

blocks|key|2370061|text|对于那些仍然感兴趣的人来说，到2020年10月左右，.NET+EF似乎可以做到这一点。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2370062|随着最新的2.1.0预览2版本的开放源码.NET客户端驱动程序的Microsoft和Azure+SQL数据库，Microsoft.Data.SqlClient，现在可以设置默认的命令超时通过连接字符串。
现在，您可以简单地通过更改连接字符串来解决超时问题，在连接字符串中，以前需要对代码进行更改，或者更改无法更改的代码。
这可能是一个问题，当您使用第三方工具，如实体框架核心迁移或EF核心数据库反向工程(脚手架)。|blockquote|2370063|参考：https://erikej.github.io/sqlclient/2020/10/26/sqlclient-commandtimeout-preview.html|offset|length|2370064|entityMap|0|LINK|mutability|MUTABLE|url|https://erikej.github.io/sqlclient/2020/10/26/sqlclient-commandtimeout-preview.html^0|0|0|3|2B|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|S|8|@]|9|@$G|T|H|U|1|V]]|A|$]]|$1|I|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

For those still interested, as of about October 2020 it looks like this might be possible with .NET EF Core.
<blockquote>
With the latest 2.1.0 preview 2 release of the open source .NET client
driver for Microsoft SQL Server and Azure SQL Database,
Microsoft.Data.SqlClient, it is now possible to set the default
command timeout via the connection string.
Now you can work around timeout issues simply by changing the
connection string, where this previously required changes to code, and
maybe changes to code you did not have the ability to change.
This could be an issue when you were using third party tools like
Entity Framework Core migrations or EF Core database reverse
engineering (scaffolding).
</blockquote>
Refer:
<a href="https://erikej.github.io/sqlclient/2020/10/26/sqlclient-commandtimeout-preview.html" rel="nofollow noreferrer">https://erikej.github.io/sqlclient/2020/10/26/sqlclient-commandtimeout-preview.html</a>

How to add CommandTimeout to connection string in web.config?

I tried:



<pre class="lang-xml prettyprint-override"><code>&lt;add name="ConnectionString" connectionString="Data Source=;Initial Catalog=;Persist Security Info=True;User ID=sa;Password=sa@123;Connect Timeout=200" providerName="System.Data.SqlClient"/&gt;

&lt;/connectionStrings&gt;
</code></pre>

and this:

<pre class="lang-xml prettyprint-override"><code>&lt;add name="MyProject.ConnectionString" 
 connectionString="Data Source=127.0.0.1;Initial Catalog=MyDB;Persist Security Info=True;CommandTimeout=60;User ID=sa;Password=saPassw0rd"
 providerName="System.Data.SqlClient" /&gt;
</code></pre>

but it didnt' work for me.

Thanks

How to add CommandTimeout to connection string in web.config

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

如何将CommandTimeout添加到web.config中的连接字符串？我试过：<add name="ConnectionString" connectionString="Data Source=;Initial Catalog=;Persist Security Info=True;User ID=sa;Pas...

问如何将CommandTimeout添加到web.config中的连接字符串
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将CommandTimeout添加到web.config中的连接字符串EN