????1?????????sqlite?????
//??????????????????????????????к????????
//????????????????sqlite???????IO????
FileStream fs = File.Create(“c:\test.db“);
//??????????SQLiteConnection
SQLiteConnection.CreateFile(“c:\test.db“);
??????????????????0?????????
????2????????????sqlite?????
????//????????????password????sqlite?????
SQLiteConnection.CreateFile??“c:\test2.db“);
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\test2.db“);
SQLiteConnection cnn = new SQLiteConnection(“Data Source=D:\test2.db“);
cnn.Open();
cnn.ChangePassword(“password“);
????3????δ?????????????
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\test.db“);
cnn.Open();
cnn.ChangePassword(“password“);
????4????????sqlite?????
//?????
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\test2.db“);
cnn.SetPassword(“password“);
cnn.Open();
//??????
SQLiteConnectionStringBuilder builder = new SQLiteConnectionStringBuilder();
builder.DataSource = @”c: est.db“;
builder.Password = @”password“;
SQLiteConnection cnn = new SQLiteConnection(builder.ConnectionString);
cnn .Open();
???????
????select * from messages limit 10??100;
???????????10?У??100?е????????