Exemple #1
0
 public static void InsertTest()
 {
     string           sql  = "INSERT INTO [TestEntity]([Title],[Content],[CreateDate]) VALUES('title1','content2' ,'1999.1.1')";
     SQLiteConnection conn = SqliteHelper.GetConnection();
     var v = conn.Execute(sql);
 }
Exemple #2
0
 public static void DeleteTest2()
 {
     string           sql  = "delete from TestEntity where id=12";
     SQLiteConnection conn = SqliteHelper.GetConnection();
     var v = conn.Execute(sql);
 }
Exemple #3
0
 public static void SelectTest()
 {
     string           sql  = "select * from testentity where id=1";
     SQLiteConnection conn = SqliteHelper.GetConnection();
     var v = conn.Query <TestEntity>(sql);
 }