title: What is the difference between connection.Close() and connection.Dispose()?
body: <p>I noticed that the <code>SQLiteConnection</code> object in <code>System.Data.SQLite</code> owns two similar methods :</p>
  
  <ul>
  <li><code>Close()</code></li>
  <li><code>Dispose()</code></li>
  </ul>
  
  <p>Same for the <code>SQLiteDataReader</code> object.</p>
  
  <p>What is the difference ?</p>