Esempio n. 1
0
 public void TestTextInsertAndDeleteNull()
 {
     DbProxyDal.InsertTextNull("001");
     DbProxyDal.QueryTextNullByReader("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.DeleteText("001");
 }
Esempio n. 2
0
        public void TestTextUpdateValueNull()
        {
            DateTime testDateTime = new DateTime(2008, 8, 8, 8, 0, 0);

            DbProxyDal.InsertTextNormal("001", long.MaxValue, int.MaxValue, short.MaxValue, byte.MaxValue, testDateTime,
                                        0.0f, 0.0, "0123456789", "0123456789", ABytes, ABytes);
            DbProxyDal.UpdateTextNull("001");
            DbProxyDal.QueryTextNullByReader("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.DeleteText("001");
        }