public void TestNullableType()
{
if( Broker.Provider.GetAnalyzer() != null && GentleSettings.AnalyzerLevel != AnalyzerLevel.None )
{
obj1 = new PHNullableType( 0, "Test", null );
// insert
obj1.Persist();
// select raw data to verify that null was written
SqlResult sr = GetRawTableData();
Assert.AreEqual( 1, sr.RowsContained );
Assert.IsNull( sr[ 0, "TDateTime" ], "Expected null to be written, but database contained the value {0}.", sr[ 0, "TDateTime" ] );
// update
obj1.NullableDate = null;
obj1.Persist();
// select raw data to verify that null was written
sr = GetRawTableData();
Assert.AreEqual( 1, sr.RowsContained );
Assert.IsNull( sr[ 0, "TDateTime" ], "Expected null to be written, but database contained the value {0}.", sr[ 0, "TDateTime" ] );
// select and verify update
obj1 = PHNullableType.Retrieve( obj1.Id );
Assert.IsNull( obj1.NullableDate, "Expected null to be read but actual value read was {0}.", obj1.NullableDate );
Assert.AreEqual( null, obj1.NullableDate );
// clean up
obj1.Remove();
}
}
public void TestNullableType()
{
if (Broker.Provider.GetAnalyzer() != null && GentleSettings.AnalyzerLevel != AnalyzerLevel.None)
{
obj1 = new PHNullableType(0, "Test", null);
// insert
obj1.Persist();
// select raw data to verify that null was written
SqlResult sr = GetRawTableData();
Assert.AreEqual(1, sr.RowsContained);
Assert.IsNull(sr[0, "TDateTime"], "Expected null to be written, but database contained the value {0}.", sr[0, "TDateTime"]);
// update
obj1.NullableDate = null;
obj1.Persist();
// select raw data to verify that null was written
sr = GetRawTableData();
Assert.AreEqual(1, sr.RowsContained);
Assert.IsNull(sr[0, "TDateTime"], "Expected null to be written, but database contained the value {0}.", sr[0, "TDateTime"]);
// select and verify update
obj1 = PHNullableType.Retrieve(obj1.Id);
Assert.IsNull(obj1.NullableDate, "Expected null to be read but actual value read was {0}.", obj1.NullableDate);
Assert.AreEqual(null, obj1.NullableDate);
// clean up
obj1.Remove();
}
}
