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

User · Answer

See - ConnectionStrings content on this subject   There is no default command timeout property

User · Answer

You can only set the connection timeout on the connection string  the timeout for your query would normally be on the command timeout    Assuming we are talking  net here  I can t really tell from your question    However the command timeout has no effect when the command is executed against a context connection  a SqlConnection opened with  context connection true  in the connection string

User · Answer

Only from code    x000D   x000D  namespace xxx DsXxxTableAdapters   x000D      partial class ZzzTableAdapter x000D        x000D          public void SetTimeout int timeout  x000D            x000D              if  this Adapter DeleteCommand    null    this Adapter DeleteCommand CommandTimeout   timeout    x000D              if  this Adapter InsertCommand    null    this Adapter InsertCommand CommandTimeout   timeout    x000D              if  this Adapter UpdateCommand    null    this Adapter UpdateCommand CommandTimeout   timeout    x000D              if  this  commandCollection    null    this InitCommandCollection      x000D              if  this  commandCollection    null  x000D                x000D                  foreach  System Data SqlClient SqlCommand item in this  commandCollection  x000D                    x000D                      if  item    null  x000D                        item CommandTimeout   timeout    x000D                    x000D                x000D            x000D        x000D    x000D             x000D    x000D     x000D   x000D   x000D

User · Answer

you can set Timeout in connection string  time for Establish connection between client and sql   commandTimeout is set per command but its default time is 30 secend

User · Answer

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

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

Examples related to c#

Examples related to sql-server