System. Data. Sqlite Getting Started Guide

Start with System. Data. Sqlite...
First import/using:

Code

1. Using System. Data. SQLite;

Connection and Command:

Code

1. Private SQLiteConnection conn;
3. Private SQLiteCommand cmd;

Connect to db:

Code

1. Conn = new SQLiteConnection ("Data Source = c: \ test. db ");
2. Conn. Open ();

INSERT/UPDATE:

 

Code

1. Cmd = conn. CreateCommand ();
2. Cmd. CommandText = "insert into user (email, name) VALUES ('email ', 'name ')";
3. Cmd. ExecuteNonQuery ();
5. Cmd. CommandText = "UPDATE userSET name = 'codelicious 'where id = 1 ";
6. Cmd. ExecuteNonQuery ();

SELECT:

 

Code

1. Cmd. CommandText = "select id, name FROM user ";
2. SQLiteDataReader reader = cmd. ExecuteReader ();
3. If (reader. HasRows)
4. {
5. While (reader. Read ())
6. {
7. Console. WriteLine ("ID:" + reader. GetInt16 (0 ));
8. Console. WriteLine ("name:" + reader. GetString (1 ));
9. }
10. }