public async Task Save_NoSequenceWithPk_CanInsert() { dynamic toSave = new { DNAME = "Massive Dep", LOC = "Beach" }.ToExpando(); { var depts = new Department(ProviderName); var result = await depts.SaveAsync(toSave); Assert.AreEqual(1, result); Assert.IsTrue(toSave.DEPTNO > 0); Assert.AreEqual(1, await depts.DeleteAsync(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 = await depts.InsertAsync(toSave); Assert.AreEqual(oldId, result.DEPTNO); Assert.AreEqual(1, await depts.DeleteAsync(toSave.DEPTNO)); } }
public async Task Delete(WorkOrder workOrder) { var db = new MightyOrm <WorkOrder>("AdventureWorks2014"); await db.DeleteAsync(workOrder); }