Michael Russell wrote:
>
> We were previously using 1.0.79.0, but in an attempt to move to VS2012 /
> .NET 4.5 I started doing some testing with 1.0.83.0. I found that many of
> our UnitTests now fail when they try to delete the temporary test database
> file they created. This happens with the SQLiteConnection() call. I can
> provide a complete VS project, but here's a code snippet that has the
> crucial parts:
>
The change was to keep the underlying native connection open until all other
native objects that refer to it have been disposed.
>
> var sqlCommand = new SQLiteCommand(connection)
> {
> CommandText = "SELECT * from User where Username='administrator'"
> };
>
If you make sure and dispose of all SQLiteCommand and SQLiteDataReader
objects
associated with a particular connection, you should not see any issue.
--
Joe Mistachkin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
