public void TestCRUD()
{
// skip test if GUIDs are not supported by database backend
if( runTest )
{
o1 = new GuidHolderIP( 42 );
// insert
o1.Persist();
// select
o2 = GuidHolderIP.Retrieve( o1.Id );
// verify select/insert
Assert.IsNotNull( o2.Id, "The object could not be retrieved from the database!" );
Assert.AreEqual( o1.Id, o2.Id, "The object could not be retrieved from the database!" );
Assert.AreEqual( o1.SomeValue, o2.SomeValue, "The object could not be retrieved from the database!" );
// update
o2.Persist();
// verify update
o1 = GuidHolderIP.Retrieve( o2.Id );
// delete
o2.Remove();
// verify delete by counting the number of rows
SqlBuilder sb = new SqlBuilder( StatementType.Count, typeof(GuidHolderIP) );
sb.AddConstraint( Operator.Equals, "Id", o1.Id );
SqlResult sr = Broker.Execute( sb.GetStatement( true ) );
Assert.AreEqual( 0, sr.Count, "Object not removed" );
}
}
public void TestCRUD()
{
// skip test if GUIDs are not supported by database backend
if (runTest)
{
o1 = new GuidHolderIP(42);
// insert
o1.Persist();
// select
o2 = GuidHolderIP.Retrieve(o1.Id);
// verify select/insert
Assert.IsNotNull(o2.Id, "The object could not be retrieved from the database!");
Assert.AreEqual(o1.Id, o2.Id, "The object could not be retrieved from the database!");
Assert.AreEqual(o1.SomeValue, o2.SomeValue, "The object could not be retrieved from the database!");
// update
o2.Persist();
// verify update
o1 = GuidHolderIP.Retrieve(o2.Id);
// delete
o2.Remove();
// verify delete by counting the number of rows
SqlBuilder sb = new SqlBuilder(StatementType.Count, typeof(GuidHolderIP));
sb.AddConstraint(Operator.Equals, "Id", o1.Id);
SqlResult sr = Broker.Execute(sb.GetStatement(true));
Assert.AreEqual(0, sr.Count, "Object not removed");
}
}
