Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the difference between connection.Close() and connection.Dispose()? [duplicate]

I noticed that the SQLiteConnection object in System.Data.SQLite owns two similar methods :

  • Close()
  • Dispose()

Same for the SQLiteDataReader object.

What is the difference ?

like image 956
Epoc Avatar asked Jun 18 '13 12:06

Epoc


2 Answers

Dispose also closes the connection if it hasn't been closed, but when calling Close, you can reopen the connection again. This is not possible when the connection is disposed.

In general, don't call Close, but simply call dispose implicitly by wrapping the creation of a connection in a using block:

using (var connection = new SqlConnection(...))
{
    // use connection here. e.g.:
    connection.Open();
    using (var command = connection.CreateCommand())
    {
        ...
    }
} // connection gets closed and disposed here.
like image 114
Steven Avatar answered Oct 16 '22 16:10

Steven


Connection.Close() will simply close the connection to the server as defined in the connection string. The Connection can be used/re-opened after this point.

Connection.Dispose() will clean up completely, removing all unmanaged resources preventing that Connection from being used again. Once disposed is called you shouldn't try to use the object any more. Within Dispose(),Close()` will all most certainly be called too.

I would recommend using the using syntax like so if possible, to ensure things are cleaned up correctly:

using(SqlLiteConnection conn = new SqlLiteConnection(...))
{
   // Do work here
}

This will automatically dispose of the connection for you, regardless of an exception being thrown.

like image 8
Ian Avatar answered Oct 16 '22 17:10

Ian