[sqlite] EF6 - SQLite file remains locked after dispose

[Joe Strommen]

Hi all,
   I'm using SQLite with Entity Framework 6 and having a problem.  I am
unable to delete the sqlite file, even though I'm disposing all my
disposable objects.  Below is a minimal code sample that demonstrates the
issue.  I'd appreciate any advice/workarounds you can provide.  I'm happy
to enter a ticket for this, but I wanted to verify that I'm not doing
something wrong first.

(I'm using the latest System.Data.SQLite NuGet package, which is version
1.0.91)

Thanks
Joe Strommen

    class Program
    {
        public class TestContext : DbContext
        {
            public TestContext(DbConnection existingConnection) :
base(existingConnection, false) { }

            public DbSet<TestEntity> TestEntities { get; set; }
        }

        public class TestEntity
        {
            public long Id { get; set; }

            public string Value { get; set; }
        }

        static void Main(string[] args)
        {
            var path = "test.sqlite";
            if (File.Exists(path)) { File.Delete(path); }
            using (var sqliteConnection = new SQLiteConnection("Data
Source=" + path))
            {
                sqliteConnection.Open();

                using (var sqliteCmd = sqliteConnection.CreateCommand())
                {
                    sqliteCmd.CommandText =
                        "CREATE TABLE TestEntities (Id INTEGER PRIMARY KEY
AUTOINCREMENT, Value TEXT);" +
                        "INSERT INTO TestEntities ('Value') VALUES
('Value1'), ('Value2'), ('Value3');";
                    sqliteCmd.ExecuteNonQuery();
                }

                using (var efContext = new TestContext(sqliteConnection))
                {
                    var entityCount = efContext.TestEntities.Count();
                }
            }
            File.Delete(path); // Fails; the file is still locked.
        }
    }
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users