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

by

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.

More Related Contents:

  1. Does SqlCommand.Dispose close the connection?
  2. What’s the best method to pass parameters to SQLCommand?
  3. Sanitize table/column name in Dynamic SQL in .NET? (Prevent SQL injection attacks)
  4. Why doesn’t Dapper dot net open and close the connection itself?
  5. Why is some sql query much slower when used with SqlCommand?
  6. When would SqlCommand.ExecuteReader() return null?
  7. Difference between decimal, float and double in .NET?
  8. LINQ to Entities does not recognize the method
  9. store image in database or in a system file? [closed]
  10. Why/when should you use nested classes in .net? Or shouldn’t you?
  11. Calling 32bit Code from 64bit Process
  12. ArgumentNullException or NullReferenceException from extension method?
  13. How to make modal dialog in WPF?
  14. Determine file type of an image
  15. How to serialize an object to XML without getting xmlns=”…”?
  16. How do you enable “Enable .NET Framework source stepping”?
  17. WPF Data Binding and Validation Rules Best Practices
  18. How to change default view location scheme in ASP.NET MVC?
  19. Option Strict On and .NET for VB6 programmers
  20. Why doesn’t ClickOnce in Visual Studio deploy content files from dependent assemblies?
  21. Changing the type of an (Entity Framework) entity that is part of an inheritance hierarchy
  22. Removing .aspx from pages using rewriteModule?
  23. Open .net framework 4.5 project in VS 2022. Is there any workaround?
  24. How can I install .NET framework as a prerequisite using Inno Setup?
  25. How to package a portable .NET library targeting .NET Core?
  26. .NET, the SqlConnection object, and multi-threading
  27. How to programmatically restart windows explorer process
  28. Using SharpZipLib to unzip specific files?
  29. What’s the best way to jSON serialize a .NET DataTable in WCF?
  30. .NET Date Compare: Count the amount of working days since a date?

Leave a Comment