SQLite Connect C # Notes

Have to spit groove, it is too pit. The following points must be noted:

2. To download two things, you have to have an officer net. One is SQLite for Windows, and one is System.Data.SQLite.
3. Download the DLL inside there is a test, it must be tested with it to be done. The connection string format above is the correct format. Note the path is to be used in this format.

   <?XML version= "1.0"?><Configuration><Startup><supportedruntimeversion= "v2.0.50727"/></Startup>  <appSettings>    <AddKey= "local"value= "Data source=d:/sqlite/football.db; Pooling=true; Failifmissing=false; password=123; "/>  </appSettings></Configuration>

5. If the report assembly is wrong, then it is the generated thing. To adjust the build mode to x86 or x64 in the project properties. This depends on the machine condition, of course any CPU is better.
7. If the program reported that file is encrypted or was not a database this error, then it is a little bit, your password is wrong. Yes, don't doubt it, it's a pit. Navicat set the wrong password, used in other programs, the password to enter the settings will not come out. Be sure to use a different tool or SQL statement to set the password.
   
9. You can use the SQLite Developer This tool, very useful.
11. The steps to create the database are as follows:cmd=> enter the Sqlite3.exe folder and enter the Sqlite3.exe xxx.db=> input. Databases (note here that you do not see the database created when you do not enter it.) ) = = input. Quit. After creation, the database is created in the Sqlite3.exe directory.

SQLite Connect C # Notes