Using MySQLConnection in C# does not close properly

by

Im unsure about mysqlconnection but the sql server counter part uses Connection pooling and does not close when you call close instead it puts it in the connection pool!

Edit: Make sure you dispose the Reader, Command, and Connection object!

Edit: Solved with the ConnectionString Parameter “Pooling=false” or the static methods MySqlConnection.ClearPool(connection) and MySqlConnection.ClearAllPools()

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. MSSQL Error ‘The underlying provider failed on Open’
  3. SQL Express connection string: mdf file location relative to application location
  4. Why always close Database connection?
  5. Pass connection string to code-first DbContext
  6. How to form a correct MySQL connection string? [closed]
  7. How to fix “The ConnectionString property has not been initialized”
  8. Persist Security Info Property=true and Persist Security Info Property=false
  9. Testing an Entity Framework database connection
  10. Allow only decimal numbers in textbox in C#
  11. Using C#, how does one figure out what process locked a file?
  12. How do I format a DateTime in a different format?
  13. Swagger UI Web Api documentation Present enums as strings?
  14. Authorization header is lost on redirect
  15. Restrict access to a specific controller by IP address in ASP.NET MVC Beta
  16. += new EventHandler(Method) vs += Method [duplicate]
  17. A .net disassembler/decompiler [closed]
  18. Is there any difference between DateTime in c# and DateTime in SQL server?
  19. How to change the color of winform DataGridview header?
  20. Await in catch block
  21. High memory consumption with Enumerable.Range?
  22. How do I find if two variables are approximately equals?
  23. Equality comparison between multiple variables
  24. Max return value if empty query
  25. Check if record in a table exist in a database through ExecuteNonQuery
  26. Read and process files in parallel C#
  27. How to get current windows username from windows service in multiuser environment using .NET
  28. Get the calling function name from the called function [duplicate]
  29. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  30. forward traffic from port X to computer B with c# “UDP punch hole into firewall”

Leave a Comment