After looking into this further, I think this is the same problem described in ticket aba4549801, which was marked resolved in Sep 2013 ( https://system.data.sqlite.org/index.html/tktview?name=aba4549801)
I will add a comment to the ticket to try to get it re-opened. Thanks Joe On Thu, Feb 27, 2014 at 2:49 PM, mm.w <0xcafef...@gmail.com> wrote: > Hello, > > is it the class you use? > > https://github.com/peterhuene/sqlite-net/blob/master/src/SQLite.cs > > then extend SQLiteConnection and overwrite > > public void Dispose () to trace what's happening > > > Best Regards. > > > On Thu, Feb 27, 2014 at 12:33 PM, mm.w <0xcafef...@gmail.com> wrote: > > > Hello, > > > > reading quickly the doc > > > > "Constructs a new context instance using the existing connection to > > connect to a database. The connection will not be disposed when the > context > > is disposed ifcontextOwnsConnection is false." > > > > base(existingConnection, false) { } > > > > Best Regards. > > > > > > On Thu, Feb 27, 2014 at 12:28 PM, Joe Strommen <joe.strom...@gmail.com > >wrote: > > > >> The end of the using() block automatically closes the connection. If I > >> remove the line with "efContext.TestEntities.Count()" then it works > fine. > >> > >> > >> On Thu, Feb 27, 2014 at 2:09 PM, mm.w <0xcafef...@gmail.com> wrote: > >> > >> > Hello, > >> > > >> > I don't know anything about c# and the Entity Framework, but > something > >> > obvious where do you close your connection? > >> > > >> > Best Regards. > >> > > >> > > >> > On Wed, Feb 26, 2014 at 11:46 AM, Joe Strommen < > joe.strom...@gmail.com > >> > >wrote: > >> > > >> > > 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 > >> > > > >> > _______________________________________________ > >> > sqlite-users mailing list > >> > sqlite-users@sqlite.org > >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
