SqlConnectionStringBuilder.ConnectTimeout Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets or sets the length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error.
public:
property int ConnectTimeout { int get(); void set(int value); };public int ConnectTimeout { get; set; }member this.ConnectTimeout : int with get, setPublic Property ConnectTimeout As IntegerProperty Value
The value of the ConnectTimeout property, or 15 seconds if no value has been supplied.
Examples
The following example first displays the contents of a connection string that does not specify the "Connect Timeout" value, sets the ConnectTimeout property, and then displays the new connection string.
using Microsoft.Data.SqlClient;
class Program
{
static void Main()
{
try
{
string connectString =
"Server=(local);Initial Catalog=AdventureWorks;" +
"Integrated Security=true";
SqlConnectionStringBuilder builder =
new SqlConnectionStringBuilder(connectString);
Console.WriteLine("Original: " + builder.ConnectionString);
Console.WriteLine("ConnectTimeout={0}",
builder.ConnectTimeout);
builder.ConnectTimeout = 100;
Console.WriteLine("Modified: " + builder.ConnectionString);
Console.WriteLine("Press any key to finish.");
Console.ReadLine();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
Remarks
This property corresponds to the "Connect Timeout", "connection timeout", and "timeout" keys within the connection string.
When opening a connection to a Azure SQL Database, set the connection timeout to 30 seconds.
Valid values are greater than or equal to 0 and less than or equal to 2147483647.