public static bool removeTaskQueueItem(int taskQueueID) { MightyOrm <TaskQueueItem> db = DatabaseConnector.createConnectionTaskQueueItem(); int numberRemoved = db.Delete(taskQueueID); if (numberRemoved > 0) { return(true); } else { return(false); } }
public void Save_NoSequenceWithPk_CanInsert() { dynamic toSave = new { DNAME = "Massive Dep", LOC = "Beach" }.ToExpando(); { var depts = new Department(ProviderName); var result = depts.Save(toSave); Assert.AreEqual(1, result); Assert.IsTrue(toSave.DEPTNO > 0); Assert.AreEqual(1, depts.Delete(toSave.DEPTNO)); } { // re-insert at the previous, deleted therefore valid, PK value but without using sequence to generate it; // actually tests that Oracle can insert user-managed PKs with no sequence var depts = new MightyOrm(string.Format(TestConstants.ReadWriteTestConnection, ProviderName), "SCOTT.DEPT", "DEPTNO"); int oldId = toSave.DEPTNO; var result = depts.Insert(toSave); Assert.AreEqual(oldId, result.DEPTNO); Assert.AreEqual(1, depts.Delete(toSave.DEPTNO)); } }