public bool Create(Section section, out int id) { using (var cn = Connection) { using (var transaction = new TransactionScope()) { cn.Open(); var success = true; id = -1; var sql = "INSERT INTO `pagesections` (`Name`) VALUES (@Name);"; success = cn.Execute(sql, section) > 0; var newId = cn.Query<ulong>("SELECT CAST(LAST_INSERT_ID() AS UNSIGNED INTEGER);").SingleOrDefault(); id = Convert.ToInt32(newId); transaction.Complete(); return success; } } }
public bool Update(Section section) { using (var cn = Connection) { var sql = "UPDATE `pagesections` SET `Name`=@Name WHERE `id`=@id;"; return cn.Execute(sql, section) > 0; } }
public bool Delete(Section section) { using (var cn = Connection) { var sql = "DELETE FROM `pagesections` WHERE `id`=@id;"; return cn.Execute(sql, section) > 0; } }