public static void UpdateTest() { SQLiteConnection conn = SqliteHelper.GetConnection(); using (var tran = conn.BeginTransaction()) { try { string sql = "update TestEntity set title='we' where id=10"; var v = conn.Execute(sql); sql = "delete from TestEntity where id=12"; var asa = conn.Execute(sql); tran.Commit(); } catch { tran.Rollback(); } } }
public static void InsertTest2() { TestEntity entity = new TestEntity(); entity.Title = "title"; entity.Content = "content"; List <string> columns = new List <string>(); foreach (var prop in entity.GetType().GetProperties()) { if (prop.Name != "Id" && prop.GetValue(entity) != null) { columns.Add(prop.Name); } } string commandText = string.Format("INSERT INTO [TestEntity]([{0}]) VALUES(@{1})", string.Join("],[", columns), string.Join(",@", columns)); SQLiteConnection conn = SqliteHelper.GetConnection(); var v = conn.Execute(commandText, entity); }
public static void DeleteTest2() { string sql = "delete from TestEntity where id=12"; SQLiteConnection conn = SqliteHelper.GetConnection(); var v = conn.Execute(sql); }
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 SelectTest() { string sql = "select * from testentity where id=1"; SQLiteConnection conn = SqliteHelper.GetConnection(); var v = conn.Query <TestEntity>(sql); }