SqlConnection.Close() inside using statement

by

No need to Close or Dispose the using block will take care of that for you.

As stated from MSDN:

The following example creates a SqlConnection, opens it, 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. Is SqlConnection.Close() need inside a 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. Delete from two tables? [closed]
  9. Insert entire DataTable into database at once instead of row by row?
  10. Is it necessary to manually close and dispose of SqlDataReader?
  11. How to execute an SSIS package from .NET?
  12. Passing List to SQL Stored Procedure
  13. DropdownList DataSource
  14. How to retrieve data from a SQL Server database in C#?
  15. Bulk Update in C#
  16. Does using parameterized SqlCommand make my program immune to SQL injection?
  17. Any way to SQLBulkCopy “insert or update if exists”?
  18. EF 6 – How to correctly perform parallel queries
  19. Multi threading C# application with SQL Server database calls
  20. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  21. How to keep single SQL Server connection instance open for multiple request in C#?
  22. Table name and table field on SqlParameter C#?
  23. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  24. Failed to update .mdf database because the database is read-only (Windows application)
  25. Sql Bulk Copy/Insert in C#
  26. GO statements blowing up sql execution in .NET
  27. Issues Doing a String Comparison in LINQ
  28. “The operation is not valid for the state of the transaction” error and transaction scope
  29. Database Error: There is no row at position 0
  30. Capturing count from an SQL query

Leave a Comment