SQLite Forum

Connection Pool always empty?

thanks for the answer. We are using .NET and so the called to the managed lib is basically:

string connectionString= $"Data Source={fileName};Cache Size=-80000;Page Size=4096;Journal Mode={SQLiteJournalModeEnum.Truncate};Pooling=True;Max Pool Size=20";
new SQLiteConnection(connectionString, true);

We then open this connection, attach a transaction and some commands, execute and commit and finally close the connection again. Do we need to keep a reference to the closed connection so its not being disposed?

Thanks BR Florian