.NET, the SqlConnection object, and multi-threading

by

The obvious solution is to just re-create the SqlConnection object every time a database call requires one – in this case, it would never be shared. Is there any reason not to do this?

On the contrary, that’s absolutely what you should do. That’s the behaviour SqlConnection was designed for. You should use a Using statement to automatically close the connection at the end of the block you’re using it for, and the connection pool mechanism will automatically handle the real underlying connections to the database.

More Related Contents:

  1. Could you explain STA and MTA?
  2. Like Operator in Entity Framework?
  3. Why did a network-related or instance-specific error occur while establishing a connection to SQL Server?
  4. Max number of concurrent HttpWebRequests
  5. Is it safe just to set CheckForIllegalCrossThreadCalls to false to avoid cross threading errors during debugging?
  6. How can I solve a connection pool problem between ASP.NET and SQL Server?
  7. Login failed for user ‘DOMAIN\MACHINENAME$’
  8. How to find foreign key dependencies in SQL Server?
  9. Update primary key value using entity framework
  10. A connection was successfully established with the server, but then an error occurred during the pre-login handshake
  11. System.Threading.Tasks – Limit the number of concurrent Tasks
  12. Where do I get a thread-safe CollectionView?
  13. Using “GO” within a transaction
  14. Unit testing a multithreaded application?
  15. Making sure OnPropertyChanged() is called on UI thread in MVVM WPF app
  16. Parallelizing GDI+ Image Resizing .net
  17. Procedure expects parameter which was not supplied
  18. TSQL md5 hash different to C# .NET md5
  19. How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?
  20. Why doesn’t Dapper dot net open and close the connection itself?
  21. “The calling thread must be STA, because many UI components require this” error when creating a WPF pop-up Window in thread
  22. How to I serialize a large graph of .NET object into a SQL Server BLOB without creating a large buffer?
  23. Using SynchronizationContext for sending events back to the UI for WinForms or WPF
  24. How to handle all unhandled exceptions when using Task Parallel Library?
  25. Unable to load DLL ‘SqlServerSpatial.dll’
  26. What does MethodImplOptions.Synchronized do?
  27. Entity Framework and Multi threading
  28. How to prevent a new WPF form from stealing focus?
  29. How to serialize a large graph of .NET objects into a SQL Server BLOB without creating a large buffer?
  30. Does Console.WriteLine block?

Leave a Comment