This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at firstname.lastname@example.org
The goal is to use lightSpeed with SQLite stored in-memory with the following scenario:
1. create migration
2. manipulate data on migrated database
According to SQLite documentation the in-memory database exists as long as connection to this database stays open. To avoid closing connections we use Connection Pooling ("Data Source=:memory:;Pooling=True;Max Pool Size=1;") but in some cases after migration we lost our connection (probably after garbage collection).