public void TestTextInsertAndDeleteNormal() { 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.QueryTextNormalByReader("001", out bigIntValue, out intValue, out smallIntValue, out tinyIntValue, out dateTimeValue, out realValue, out floatValue, out varcharText, out charText, out varbinaryStream, out binaryStream); Assert.AreEqual(long.MaxValue, bigIntValue); Assert.AreEqual(int.MaxValue, intValue); Assert.AreEqual(short.MaxValue, smallIntValue); Assert.AreEqual(byte.MaxValue, tinyIntValue); Assert.AreEqual(testDateTime, dateTimeValue); Assert.AreEqual(0.0f, realValue); Assert.AreEqual(0.0, floatValue); Assert.AreEqual("0123456789", varcharText); Assert.AreEqual("0123456789", charText); for (int i = 0; i < 50; i++) { Assert.AreEqual((byte)'A', varbinaryStream[i]); Assert.AreEqual((byte)'A', binaryStream[i]); } DbProxyDal.DeleteText("001"); }
public void TestProcInsertAndDeleteScalar() { 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); int linenum, returnValue; DbProxyDal.QueryProcNormalByScalar("001", out linenum, out returnValue); Assert.AreEqual(1, linenum); Assert.AreEqual(1, returnValue); DbProxyDal.DeleteProc("001"); }
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"); }
public void TestAccessTimeout() { DbProxyDal.AccessTimeout(); }