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