Is there a way to programmatically add a new connection from a query?
Options
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);