c# - how to set the query timeout from SQL connection string

Question

I want to set the querytimeout from the connection string. not the connection timeout, is it possible?

question from:https://stackoverflow.com/questions/1198951/how-to-set-the-query-timeout-from-sql-connection-string

Answer 1

No. It's per command, not per connection.

Edit, May 2013

As requested in comment:

• SQLCommand.CommandTimeout for command execution
• There is no matching SQLConnection property (the questions says not the SqlConnection.ConnectionTimeout property

Some more notes about commands and execution time outs in SQL Server (DBA.SE). And more SO stuff: What happens to an uncommitted transaction when the connection is closed?