public void TestProcInsertAndDeleteNull()
{
DbProxyDal.InsertProcNull("001");
DbProxyDal.QueryProcNullByReader("001", out bigIntNull, out intNull, out smallIntNull, out tinyIntNull, out dateTimeNull,
out realNull, out floatNull, out varcharNull, out charNull, out varbinaryNull,
out binaryNull);
Assert.AreEqual(true, bigIntNull);
Assert.AreEqual(true, intNull);
Assert.AreEqual(true, smallIntNull);
Assert.AreEqual(true, tinyIntNull);
Assert.AreEqual(true, dateTimeNull);
Assert.AreEqual(true, realNull);
Assert.AreEqual(true, floatNull);
Assert.AreEqual(true, varcharNull);
Assert.AreEqual(true, charNull);
Assert.AreEqual(true, varbinaryNull);
Assert.AreEqual(true, binaryNull);
DbProxyDal.DeleteProc("001");
}
public void TestProcUpdateValueNull()
{
DateTime testDateTime = new DateTime(2008, 8, 8, 8, 0, 0);
DbProxyDal.InsertProcNormal("001", long.MaxValue, int.MaxValue, short.MaxValue, byte.MaxValue, testDateTime,
0.0f, 0.0, "0123456789", "0123456789", ABytes, ABytes);
DbProxyDal.UpdateProcNull("001");
DbProxyDal.QueryProcNullByReader("001", out bigIntNull, out intNull, out smallIntNull, out tinyIntNull, out dateTimeNull,
out realNull, out floatNull, out varcharNull, out charNull, out varbinaryNull,
out binaryNull);
Assert.AreEqual(true, bigIntNull);
Assert.AreEqual(true, intNull);
Assert.AreEqual(true, smallIntNull);
Assert.AreEqual(true, tinyIntNull);
Assert.AreEqual(true, dateTimeNull);
Assert.AreEqual(true, realNull);
Assert.AreEqual(true, floatNull);
Assert.AreEqual(true, varcharNull);
Assert.AreEqual(true, charNull);
Assert.AreEqual(true, varbinaryNull);
Assert.AreEqual(true, binaryNull);
DbProxyDal.DeleteProc("001");
}