SQLite locking file even though connection is closed

Question

Shouldn`t the following statement be autocommited? I get an IOException trying to delete the file after executing the query.

using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + AppDomain.CurrentDomain.BaseDirectory + "data\\test.db;Version=3;"))
{
    connection.Open();
    SQLiteCommand command = new SQLiteCommand("CREATE TABLE IF NOT EXISTS test (id INTEGER)", connection);
    command.ExecuteNonQuery();
}

//throwing an IOException
File.Delete(AppDomain.CurrentDomain.BaseDirectory + "data\\test.db");

Answer 1

I'm late to the party, but I had to:

GC.WaitForPendingFinalizers();
GC.Collect();

Prior to calling File.Delete().

Answer 2

Isn't the SQLiteCommand also Dispose(able)? The connection might not close because you haven't closed the command yet. I'd use a using for that too.

Answer 3

You have to dispose of every SQLiteConnection, SQLiteCommand and SQLiteDataReader once you are done using it. Simply create the SQLiteCommand within a "using" block and the problem will go away.