

SqliteCmd.CommandText = "SELECT * FROM names" Var sqliteCmd = sqliteConn.CreateCommand() Var sqliteConn = new Source=c:\MyDB.db") The complete application looks like this. Here is the complete code listing for my DB, it runs a simple select and prints out each name in the namestable.

Right click on references -> Add Reference.

To add a reference to the SQLite DLL in your project preform the following actions under the solution explorer tab. Give it a name and choose a location to save.net 4) for my test, feel free to use whatever version you want. I am going to be creating a console application (using. Next up we need to create a blank VS2010 project to test our code in.

We will be using the DLL directly so if you don’t want to register it in the GAK you don’t have to. Please make a note of where you install SQLite to! Create a new VS2010 project This is simple enough, just download the right version of SQLite for your environment and run the installer.
