C # operating SQLite

SQLite is a lightweight database. Today, we have basically mastered how to use C # To operate SQLite databases. Based on the experiences of netizens, there are at least two methods to call SQLite, one is to call sqlite3.dll and the other is to use system. data. SQLite, that is, SQLite. ADO. net is a SQLite function specially encapsulated for C sharp. It is very popular.

Briefly describe the process and take notes for future reference:

(1) download SQLite. Ado. net, install it, and findProgram, There is a configuration program that will automatically detect Compatible C sharp development environment, select it;

(2) create a new project. Enter using system. data. You will find that the prompt below does not contain SQLite. What is going on? To add a reference, select Add reference in the English environment, select project/Add reference in the Chinese menu, select system. Data. SQLite in the dialog box, and enterCodeThe prompt Code contains SQLite;

(3) then the environment is ready. The following job is to familiarize yourself with how to operate the database. It mainly includes the following aspects:

3.1 create a database file

3.2 Create a database

3.3 create a data table

3.4 add a record

3.5 update a record

3.6 delete a record

3.7 select a record

3.8 select all records

There are also a lot of specific code on the Internet. You can find it by searching carefully. Here we will not list them one by one. Next time! Pai_^