Is SqlConnection.Close() need inside a Using statement?

by

There is no need to Close (or Dispose) here; the using block will take care of that for you.

As stated from Microsoft Learn:

The following example creates a SqlConnection, opens it, [and] displays some of its properties. The connection is automatically closed at the end of the using block.

private static void OpenSqlConnection(string connectionString) 
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        Console.WriteLine("ServerVersion: {0}", connection.ServerVersion);
        Console.WriteLine("State: {0}", connection.State);
    } 
}

More Related Contents:

  1. SqlConnection.Close() inside using statement
  2. SQL WHERE clause matching values with trailing spaces
  3. Code to validate SQL Scripts
  4. Received an invalid column length from the bcp client for colid 6
  5. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  6. Use SQL Server time datatype in C#.NET application?
  7. Generating sql code programmatically
  8. SQL Server Char/VarChar DateTime Error [closed]
  9. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  10. How to get last inserted id?
  11. What is the syntax for an inner join in LINQ to SQL?
  12. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  13. How to deploy application with sql server database on clients
  14. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  15. SqlConnection SqlCommand SqlDataReader IDisposable
  16. SqlBulkCopy from a List
  17. Executing query with parameters
  18. How to disable cascade delete for link tables in EF code-first?
  19. Join and Include in Entity Framework
  20. Accessing directly a Sql Server Database in Xamarin.Forms
  21. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  22. How to pass string array in SQL parameter to IN clause in SQL
  23. Check if a SQL table exists
  24. How to create Microsoft Access database in C# programmatically?
  25. Passing datatable to a stored procedure
  26. Writing driver class generic for any database support
  27. Should the order of LINQ query clauses affect Entity Framework performance?
  28. How do I connect to a SQL database from C#?
  29. Database Error: There is no row at position 0
  30. Capturing count from an SQL query

Leave a Comment