System.Data.SQLite

When reading data from an SQLite database file using Entity Framework 6, the file keeps locked even after the context is disposed. I use the latest System.Data.SQLite package from Nuget.

using (var conn = new SQLiteConnection(@"Data Source=test.db3"))
using (var context = new DatabaseContext(conn))
{
	var value = context.TestTable.First().TestField;
	Console.WriteLine(value);
}
File.Move(@"test.db3", @"test2.db3"); // System.IOException occurs there - the file is locked.

VS2015 solution that shows the problem:
[https://dl.dropboxusercontent.com/u/42211465/SQLiteEF6FileIssue.zip]

This is most likely the same as an issue we saw before.  The Entity Framework
does not dispose of all IDisposable resources, which prevents them (and their
associated connection) from being cleaned up, hence the lock.

In my experience, closing the database connection directly doesn't solve the problem either. According to this StackOverflow answer [http://stackoverflow.com/a/8513453/136062], System.Data.SQLite isn't actually releasing its hold on the file until a garbage-collection cycle finalizes the connection.

My code has to issue a GC.Collect() and GC.WaitForPendingFinalizers() to successfully release SQLite's locks on the database.

It's the Entity Framework that is not disposing of all its IDisposable database
resources that is the root cause of this problem.  Case closed.