public void Execute_ParameterCharNoSizeSet_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); Assert.AreEqual("abcdefghij", proc.ParameterChar); }
public void Execute_ParameterDateTimeNoSizeSet_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); Assert.AreEqual(new DateTime(1990, 12, 4, 6, 44, 4), proc.ParameterDateTime); }
public void Execute_ParameterBitNoSizeSet_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); Assert.AreEqual(true, proc.ParameterBit); }
public void Execute_ParameterBinaryNoSizeSet_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); var expectedBinary = GetBytes("michael rodda"); Assert.AreEqual(expectedBinary, proc.ParameterBinary); }
public void Execute_ParameterDateTimeOffsetNoSizeSet_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); Assert.AreEqual(new DateTimeOffset(2007, 05, 08, 12, 35, 29, 123, new TimeSpan(0, 12, 15, 0)), proc.ParameterDateTimeOffset); }
public void Execute_ParameterDateTime2NoSizeSet_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); Assert.AreEqual(new DateTime(1968, 10, 23, 12, 45, 37, 123), proc.ParameterDateTime2); }
public void Execute_ParameterXml_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); Assert.AreEqual("<Some><Xml /></Some>", proc.ParameterXml); }
public void Execute_ParameterVarChar_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); Assert.AreEqual("Once upon a time", proc.ParameterVarChar); }
public void Execute_ParameterVarBinary_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); Assert.AreEqual(GetBytes("mike rodda"), proc.ParameterVarBinary); }
public void Execute_ParameterUniqueIdentifier_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); Assert.AreEqual(new Guid("692623c2-a71e-453f-98c6-432c67835ba4"), proc.ParameterUniqueIdentifier); }
public void Execute_ParameterTimeNoSizeSet_CorrectValueReturned() { var proc = new AllTypesParameterOutputStoredProcedure(); ExecuteStoredProcedure<ParameterSizeStoredProcedureReturn>(proc); Assert.AreEqual(new TimeSpan(0, 13, 3, 2), proc.ParameterTime); }