ado.net Closing Connection when using “using” statement

by

The using will take care of it for you. Under the hood, SqlConnection.Dispose() calls the SqlConnection.Close() method, and SqlCommand.Dispose() calls SqlCommand.Close().

As additional background, a using statement is syntactic sugar for a try ... finally that disposes the IDisposable object in the finally.

More Related Contents:

  1. Use of SqlParameter in SQL LIKE clause not working
  2. WHERE IN (array of IDs)
  3. SQL: Update a row and returning a column value with 1 query
  4. Passing array to a SQL Server Stored Procedure
  5. How to pass an array into a SQL Server stored procedure
  6. Call a stored procedure with parameter in c#
  7. Calling stored procedure with return value
  8. Get output parameter value in ADO.NET
  9. OleDbCommand parameters order and priority
  10. How to pass sqlparameter to IN()? [duplicate]
  11. Invalid attempt to read when no data is present
  12. Populate data table from data reader
  13. Difference with Parameters.Add and Parameters.AddWithValue
  14. How to save image in database using C# [closed]
  15. DbArithmeticExpression arguments must have a numeric common type
  16. Connection timeout for SQL server
  17. MultipleActiveResultSets=True or multiple connections?
  18. Getting binary data using SqlDataReader
  19. How to fill a datatable with List [duplicate]
  20. How to fill Dataset with multiple tables?
  21. How DataReader works?
  22. Generate class from database table
  23. Enabling Foreign key constraints in SQLite
  24. How do I calculate the equivalent to SQL Server (hashbytes(‘SHA1’,[ColumnName])) in C#?
  25. How to in-code supply the password to a connection string in an ADO.Net Entity Data Model
  26. How to get efficient Sql Server deadlock handling in C# with ADO?
  27. ADO.Net Entity Framework An entity object cannot be referenced by multiple instances of IEntityChangeTracker
  28. Generating sql code programmatically
  29. Do we have transactions in MS-Access?
  30. How do you Sort a DataTable given column and direction?

Leave a Comment