SqlConnection.ConnectionTimeout 属性

定义

命名空间:
System.Data.SqlClient
程序集:
System.Data.dll

获取在终止尝试并生成错误之前尝试建立连接的时间（以秒为单位）。

public:
 property int ConnectionTimeout { int get(); };
public:
 virtual property int ConnectionTimeout { int get(); };
[System.Data.DataSysDescription("SqlConnection_ConnectionTimeout")]
public int ConnectionTimeout { get; }
public override int ConnectionTimeout { get; }
[<System.Data.DataSysDescription("SqlConnection_ConnectionTimeout")>]
member this.ConnectionTimeout : int
member this.ConnectionTimeout : int
Public ReadOnly Property ConnectionTimeout As Integer
Public Overrides ReadOnly Property ConnectionTimeout As Integer

属性值

Int32

等待连接打开的时间（以秒为单位）。 默认值为 15 秒。

实现

ConnectionTimeout
属性
DataSysDescriptionAttribute

例外

ArgumentException

设置的值小于 0。

示例

以下示例在连接字符串中创建并 SqlConnection 设置为 Connection Timeout 30 秒。 代码将打开连接，并在控制台窗口中显示 ConnectionTimeout 属性。

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

注解

可以使用连接字符串中的或Connect Timeout关键字设置连接等待超时Connection Timeout的时间量。 值为 0 表示没有限制，应避免在 ConnectionString 尝试无限期连接时等待。

适用于

另请参阅