public void Test_2_TestInsert2() { var newItem = new testTable { Name = "SomeOther", Note = "important" }; (new BattleAxe.ProcedureDefinition("testTable_Update", ConnectionString)).Execute(newItem); Assert.IsTrue(newItem.TestID > 0); }
public void Test_1_TestInsert() { var newItem = new testTable { Name = "new thing", Note = "important" }; "testTable_Update".Execute(ConnectionString, newItem); Assert.IsTrue(newItem.TestID > 0); }
public void TestInsert() { var newItem = new testTable { name = "new thing", value = "important" }; "testTable_Update".GetCommand(ConnectionString).Execute(newItem); var item = $"SELECT * FROM testTable WHERE id ={newItem.id}".GetCommand(ConnectionString, System.Data.CommandType.Text).FirstOrDefault<testTable>(); Assert.IsTrue(item != null && item.value == newItem.value && item.name == newItem.name); }