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));
}
}