public void Parameter_ExecuteAsNull_NoErrors()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterSmallDateTime = null;
Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
}
public void Parameter_ExecuteAsNull_NoErrors()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterUniqueIdentifier = null;
Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
}
public void Parameter_Execute_NoErrors()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterNText = "Michael";
Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
}
public void Parameter_Execute_NoErrors()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterSmallInt = 653;
Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
}
public void Parameter_Execute_NoErrors()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterTime = new TimeSpan(0, 11, 6, 10, 44);
Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
}
public void Parameter_Execute_NoErrors()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterDateTime2 = new DateTime(1983, 11, 10);
Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
}
public void Parameter_Execute_NoErrors()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterXml = "<Root />";
Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
}
public void Parameter_Execute_NoErrors()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterImage = new byte[100];
Assert.DoesNotThrow(() => ExecuteStoredProcedure(procedure));
}
public void Parameter_Execute_CorrectValueSet()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterReal = 656;
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual(656, result.ParameterReal);
}
public void Parameter_Execute_CorrectValueSet()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterChar = "Michael";
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual("Michael " /* CHAR(10) */, result.ParameterChar);
}
public void Parameter_Execute_CorrectValueSet()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterSmallInt = 777;
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual(777, result.ParameterSmallInt);
}
public void Parameter_Execute_CorrectValueSet()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterImage = GetBytes("michael rodda");
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual(GetBytes("michael rodda"), result.ParameterImage);
}
public void Parameter_Execute_TimeSet()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterDateTime2 = new DateTime(1983, 11, 10, 16, 30, 15);
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual(new DateTime(1983, 11, 10, 16, 30, 15), result.ParameterDateTime2);
}
public void Parameter_Execute_CorrectValueSet()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterXml = "<Root />";
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual("<Root />", result.ParameterXml);
}
public void Parameter_Execute_CorrectValueSet()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterTime = new TimeSpan(0, 4, 13, 10, 44);
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual(new TimeSpan(0, 4, 13, 10, 44), result.ParameterTime);
}
public void Parameter_Execute_CorrectValueSet()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterNText = "michael";
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual("michael", result.ParameterNText);
}
public void Parameter_Execute_MinutesRoundedUp()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterSmallDateTime = new DateTime(1983, 11, 10, 16, 35, 30);
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual(new DateTime(1983, 11, 10, 16, 36 /* rounded up as seconds passed => 30 */, 0), result.ParameterSmallDateTime);
}
public void Parameter_Execute_CorrectValueSet()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterSmallDateTime = new DateTime(1983, 11, 10);
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual(new DateTime(1983, 11, 10), result.ParameterSmallDateTime);
}
public void Parameter_Execute_CorrectValueSet()
{
var procedure = new AllTypesStoredProcedure();
procedure.ParameterDateTimeOffset = new DateTimeOffset(1983, 11, 11, 13, 45, 59, new TimeSpan(0, 2, 10, 0));
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual(new DateTimeOffset(1983, 11, 11, 13, 45, 59, new TimeSpan(0, 2, 10, 0)), result.ParameterDateTimeOffset);
}
public void Parameter_Execute_CorrectValueSet()
{
Guid guid = Guid.NewGuid();
var procedure = new AllTypesStoredProcedure();
procedure.ParameterUniqueIdentifier = guid;
var result = ExecuteStoredProcedureSingle<AllTypesStoredProcedureReturn>(procedure);
Assert.AreEqual(guid, result.ParameterUniqueIdentifier);
}
