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);
}
