What is the difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout?

.net sqlconnection sqlcommand
Dhanapal picture Dhanapal · May 11, 2009 · Viewed 67.1k times · Source

Is there any difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout in .NET?

Answer

Jon Skeet picture Jon Skeet · May 11, 2009

Yes. CommandTimeout is how long a single command can take to complete. ConnectionTimeout is how long it can take to establish a connection to the server to start with.

For instance, you may be executing relatively long-running queries - it's perfectly okay for them to take 10 minutes to complete, but if it took 10 minutes to make the connection to start with, you'd know that something was badly wrong.

Related questions

Does SqlCommand.Dispose close the connection?

Can I use this approach efficiently? using(SqlCommand cmd = new SqlCommand("GetSomething", new SqlConnection(Config.ConnectionString)) { cmd.Connection.Open(); // set up parameters and CommandType to StoredProcedure etc. etc. cmd.ExecuteNonQuery(); } My concern is : Will the Dispose method of the SqlCommand (…

Read More
Failed to convert parameter value from a String to a Decimal

Im importing a csv to my sql server table using the following code SqlCommand nonqueryCommand = myConnection.CreateCommand(); nonqueryCommand.CommandText = "INSERT INTO MYTABLE VALUES(@num1, @num2,@num3,@num4)"; nonqueryCommand.Parameters.Add("@num1",SqlDbType.Decimal); nonqueryCommand.Parameters.Add("@num2", SqlDbType.Decimal); nonqueryCommand.…

Read More
Changing SqlConnection timeout

I am trying to override the default SqlConnection timeout of 15 seconds and am getting an error saying that the property or indexer cannot be assigned because it is read only. Is there a way around this? using (SqlConnection connection = new …

Read More