System.Data.SQLite

I ofter use sqlite for unit test. The way I use it is copy the db file to c:\ when "SetUp", delete it when "TearDown".

It works fine until version 1.0.44.0.

When I use 1.0.45.0 or 1.0.46.0 it failed with an exception said the file can not be deleted or created because others hold it.

Any idea about that?

Thanks.

I was thinking that may cause by new configurtion of "Pooling", but whatever I set it as "true" or "false", it all failed.

Thanks.

For what it is worth I have the same issue with 1.0.46. After closing and even explicitly disposing of a sqliteconnection I cannot copy a database from the desktop to my pocketpc because it is in use still.

You've probably got an un-Dispose()'d command or datareader or transaction on the connection.  I plan on implementing some sort of fix for this in the next release ... ideally it is best to always make sure you dispose of all the objects when you're done with them.

Robert

Yes, I only close/dispose the connection but not dispose the command.

I'll try it by dispose command.

Thanks.

It works. Thanks.