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