SqlConnection.ConnectionTimeout 属性
定义
获取在尝试建立连接时终止尝试并生成错误之前所等待的时间(以秒为单位)。Gets the time to wait (in seconds) while trying to establish a connection before terminating the attempt and generating an error.
public:
virtual property int ConnectionTimeout { int get(); };
public:
property int ConnectionTimeout { int get(); };
public override int ConnectionTimeout { get; }
[System.Data.DataSysDescription("SqlConnection_ConnectionTimeout")]
public int ConnectionTimeout { get; }
member this.ConnectionTimeout : int
[<System.Data.DataSysDescription("SqlConnection_ConnectionTimeout")>]
member this.ConnectionTimeout : int
Public Overrides ReadOnly Property ConnectionTimeout As Integer
Public ReadOnly Property ConnectionTimeout As Integer
属性值
等待连接打开所需的时间(以秒为单位)。The time (in seconds) to wait for a connection to open. 默认值为 15 秒。The default value is 15 seconds.
实现
- 属性
例外
设置的值小于 0。The value set is less than 0.
示例
下面的示例创建一个 SqlConnection ,并 Connection Timeout 在连接字符串中将设置为30秒。The following example creates a SqlConnection and sets the Connection Timeout to 30 seconds in the connection string. 该代码会打开连接,并 ConnectionTimeout 在控制台窗口中显示属性。The code opens the connection and displays the ConnectionTimeout property in the console window.
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 。You can set the amount of time a connection waits to time out by using the Connect Timeout or Connection Timeout keywords in the connection string. 如果值为0,则表示没有限制,应避免在中, ConnectionString 因为尝试无限期地等待连接。A value of 0 indicates no limit, and should be avoided in a ConnectionString because an attempt to connect waits indefinitely.