Is there a way to programmatically add a new connection from a query?
LINQPad does not appear to support encrypted sqlite databases, so I have written a .linq query to decrypt the database, resulting in a sqlite database that is unencrypted.
I would then like to add a connection (the equivalent of adding with Alt+Shift+N) to the unencrypted database programmatically from within the .linq query. Is this possible?
Comments
Can't answer your direct question, but I'll raise another possibility. What prevents you from using your unencrypted sqlite database in the same way you can in a non-LINQPad project?
Result from a quick search: C# SQLite
If I had this issue, I would probably just create a second linq query that referenced the unencrypted database and have the first query call this using
Util.OpenQuery( query2, run:true);