Changing SqlConnection timeout

Question

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 SqlConnection(Database.EstimatorConnection)) { connection.Open(); using (SqlCommand command = connection.CreateCommand()) { command.CommandType = CommandType.StoredProcedure; connection.ConnectionTimeout = 180; // This is not working command.CommandText = "sproc_StoreData"; command.Parameters.AddWithValue("@TaskPlanID", order.Projects[0].TaskPlanID); command.Parameters.AddWithValue("@AsOfDate", order.IncurDate); command.ExecuteNonQuery(); } } ```

Accepted Answer

If you want to provide a timeout for a particular query, then CommandTimeout is the way forward.

Its usage is:

```
command.CommandTimeout = 60; //The time in seconds to wait for the command to execute. The default is 30 seconds.
```

Changing SqlConnection timeout

Solution

Problem