DuckDbConnection can be open only once per .db file. So I have the connection as a singleton. My service has got a lot of unmanagement memory. At some point I must dispose the connection. What is the bast way to do it thread safely?
I recreate DuckDbConnection connection at midnight with timer.
New contributor
Vadym Kurinnyi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.