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

c# .net system.data.sqlite
Epoc picture Epoc · Jun 18, 2013 · Viewed 30.4k times · Source

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 ?

Answer

Steven picture Steven · Jun 18, 2013

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.
} // connection gets closed and disposed here.

Related questions

What 'additional configuration' is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?

I have a project in which I'd like to use some of the .NET 4.0 features but a core requirement is that I can use the System.Data.SQLite framework which is compiled against 2.X. I see mention of this being …

Read More
SQLite Database Locked exception

I am getting Database is locked exception from SQLite for some queries only. Below is my code: When I execute any select statement it works fine. When I am executing any write statement on Jobs Table it also works fine. …

Read More
Find object for given primary key in entity framework

I have a table "Customer" and it's corresponding ORMapping Entity Customer in entity framework and I want to find an object corresponding to a given primary key. Something like customerobject.getbjectByID() instead of lambda expression or query.

Read More