Previously I used SQLite Database Browser to create a SQLite database, now i gonna use LINQPad to connect it, to verify it’s actually a “standard” SQLite database, then maybe i can program to access it later. I am just paranoid.
OK, Step 1: Run your LINQPad, Click Add connection like the screenshot below.
There is no Data Driver for SQLite in a new installed LINQPad, then Step 2: Click View More Drivers… button
Step 3: Find the IQ Driver, click Download & Enable Driver.
Step 4: Now you have the right Data Driver, choose it and click Next >.
Step 5: set Provider to SQLite, set right Location of database file, fill other info if necessary.
Voila! it’s a real SQLite db, i can see the data scheme, i can run a query, i still prefer SQL as you can see.
Quite easy steps but not in the LINQPad document, just write it in case i forget one day.