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);
}
public static void DeleteTest2()
{
string sql = "delete from TestEntity where id=12";
SQLiteConnection conn = SqliteHelper.GetConnection();
var v = conn.Execute(sql);
}
public static void SelectTest()
{
string sql = "select * from testentity where id=1";
SQLiteConnection conn = SqliteHelper.GetConnection();
var v = conn.Query <TestEntity>(sql);
}