SqlConnection.ConnectionTimeout 属性
定义
重要
一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。 对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。
获取在尝试建立连接时终止尝试并生成错误之前所等待的时间（以秒为单位）。
public:
virtual property int ConnectionTimeout { int get(); };public:
property int ConnectionTimeout { int get(); };C#
public override int ConnectionTimeout { get; }C#
[System.Data.DataSysDescription("SqlConnection_ConnectionTimeout")]
public int ConnectionTimeout { get; }member this.ConnectionTimeout : int[<System.Data.DataSysDescription("SqlConnection_ConnectionTimeout")>]
member this.ConnectionTimeout : intPublic Overrides ReadOnly Property ConnectionTimeout As IntegerPublic ReadOnly Property ConnectionTimeout As Integer等待连接打开所需的时间（以秒为单位）。 默认值为 15 秒。
- 属性
设置的值小于 0。
以下示例创建 ，SqlConnection并将 Connection Timeout 连接字符串 设置为 30 秒。 该代码将打开连接并在控制台窗口中显示 ConnectionTimeout 属性。
C#
private static void OpenSqlConnection()
{
string connectionString = GetConnectionString();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
Console.WriteLine("State: {0}", connection.State);
Console.WriteLine("ConnectionTimeout: {0}",
connection.ConnectionTimeout);
}
}
static private string GetConnectionString()
{
// To avoid storing the connection string in your code,
// you can retrieve it from a configuration file, using the
// System.Configuration.ConfigurationSettings.AppSettings property
return "Data Source=(local);Initial Catalog=AdventureWorks;"
+ "Integrated Security=SSPI;Connection Timeout=30";
}
Private Sub OpenSqlConnection()
Dim connectionString As String = GetConnectionString()
Using connection As New SqlConnection(connectionString)
connection.Open()
Console.WriteLine("State: {0}", connection.State)
Console.WriteLine("ConnectionTimeout: {0}", connection.ConnectionTimeout)
End Using
End Sub
Private Function GetConnectionString() As String
' To avoid storing the connection string in your code,
' you can retrieve it from a configuration file, using the
' System.Configuration.ConfigurationSettings.AppSettings property
Return "Data Source=(local);Database=AdventureWorks;" _
& "Integrated Security=SSPI;Connection Timeout=30;"
End Function
可以使用 连接字符串 中的 或 Connection Timeout 关键字设置连接等待超时Connect Timeout的时间量。 值为 0 表示没有限制，应避免在 中 ConnectionString 执行连接，因为尝试连接会无限期等待。
适用于
| 产品 | 版本 |
|---|---|
| .NET | Core 1.0, Core 1.1, 6 (package-provided), 7 (package-provided), 8 (package-provided), 9 (package-provided), 10 (package-provided) |
| .NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
| .NET Standard | 2.0 (package-provided) |
